Export 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 export utility provides a way to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. Export extracts the object definitions and table data from an Oracle database and stores them in an Oracle binary format export dump file located on the file system.

Such files can then be transferred using FTP, e-mail, and so on or even physically transported using tape or floppy disk. The files can then be used with the Oracle import utility to transfer data between databases that are on machines that are not connected through a network.

A typical export job started from the command line looks like the following:

exp <user>/<password>@<database> owner=<user>

The <user> is typically the owner of the tables; you only need the owner option if you export the data logged in as administrator. Instead of exporting all of the user's objects, you can export tables by defining a comma-separated list: tables=(component,udf_component). If you have a longer list of tables, you typically would not include them all in the command line, but you would edit a text file containing all parameters for the export. Starting the export would be done with the following:

exp <user>/<password>@<database> parfile=myparms.txt

The parameter file can look like the following:

FILE=expdat.dmp

TABLES=(component,udf_component)

LOG=exp.log

With the FILE option, you can determine the name of the resulting dump file. The LOG option specifies the name and location of the export log file.

For Smart Materials, you must at least export the plant, plant_area, plant_area_unit, and the component table if you want import the Instrument or Hookup entity types. Additionally, you must export each table you specify in A.50.04 or IN 10.01 (Hookup View, Cable Drum View) for your import.