Databases Reference
In-Depth Information
3.
Change your current active folder to the location of your exported .sql file. For
instance, if your current active folder is
d:\zipdir
, you must first change the
active folder to this location. You can do so using this code:
define dir=D:\zipdir
In the next line, type in
&dir
(prefixed with the alias symbol (@)), followed by
the name of the exported file. For example, if you exported your file earlier as
f103.sql, type
@&dir\f103
in the SQL*Plus command prompt (as shown in
Figure 9-15).
4.
Tip
You can also declare the full path directly in this fashion:
@d:\zipdir\f103.sql
Figure 9-15.
Setting the active directory in SQL*Plus
5.
When you run the script, you should see a bunch of log messages scroll by. At
the end of a successful installation, you should see the screen shown in Figure
9-16.