The Oracle import utility inserts the data objects extracted from one Oracle database by the export utility (and stored in an export dump file) into another Oracle database.
The import can be started from command line using the following syntax:
imp userid=SmartPlant Instrumentation/SmartPlant Instrumentation@<database> file=expdat.dmp fromuser=<SmartPlant InstrumentationDBuser> touser=SmartPlant Instrumentation
The user "Smart Instrumentation" from the example in previous section is used again. The fromuser option allows you to specify the name of the schema user where you exported the data from, and touser is the destination. If you export, for example, a schema in Smart Instrumentation logged in as the owner and you create the same user in the Smart Materials database, you do not need to specify the fromuser and touser. However, if you export as "system", for example, and import to another user in the Smart Materials database, you need both of the fromuser and touser names. To export the data of one user into a schema of a different user, you must either log on to the Smart Materials database with the same user account used to create the dump, or you must log in with administrator privileges. As described with the export utility, you can use the parfile option to point to a text file where all your options are stored.