Import the Dmp File

To import the blank schema database (AfmoScm9.dmp or AfmoScm11.dmp) into this tablespace, you use a batch file similar to the AfmoHcn9.Bat and AfmoHcn11.Bat files. This batch file runs the SQL script and invokes the Oracle import utility with a command line. Notice that the Oracle import changes all files owned by "AFM" in the Dmp file to be owned by "HCN" in the actual database by using the "fromuser" and "touser" parameters.

sqlplus @AfmoHcn_Perm9.Sql
imp system/manager fromuser=afm touser=hcn
file=AfmoScm.Dmp grants=n log=AfmoScm.Log

Alternately, you can run the script using SQL Worksheet and use the Oracle Data Manager to perform a Full Database Import on the AfmoScm.dmp file.