Oracle Tips by Burleson
Importing and Running the DDLscript
Now that all the files are needed have been
identified, it is time to import them. This example assumes that the
tablespace has been created, HTML DB has been installed, and a
workspace has been created.
With that done, the first step is to import the
DDL script and execute it. This step is performed in two parts. The
first part is uploading the DDL script, and the second part is running
the script. Again, HTML DB makes all this easy!
Navigate to the SQL Script repository page: SQL Workshopą SQL
Scripts. This page was shown in Figure 14.2.
To upload the easy_script.sql file, click on the Upload button.
On the Upload Script page, as shown in Figure 14.8:
File: Enter the filename for the
easy_script.sql file exported earlier.
Script Name: Assuming you were in a
different environment, the name shown in Figure 14.8 would be
Click the Upload button.
Now, the script needs to be executed. It is
simple; just click on the traffic light icon under the Run column.
HTML DB will give a confirmation screen, shown in Figure 14.9.
Click on the Run button and the script will execute. If there are
errors, they will be displayed. The script can then be edited and
The above book excerpt is from:
Oracle Application Express
Dynamic Web Pages with OAE
Michael Cunningham & Kent Crotty