Import Smart Instrumentation Data - Intergraph Smart Materials - Version 10.1 - Administration & Configuration - Hexagon

Intergraph Smart Materials Integration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Construction Version
8
Smart Materials/Smart Reference Data Version
10.1

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.