Previous | Table of Contents | Next

Page 313

Parameter Default Value Description
RECORD Y If using the INCTYPE parameter with RECORD=Y, the SYS data dictionary tables INCEXP, INCFIL, and INCVID are populated with export data such as owner, type of export, and the time of export.
RECORD_LENGTH OS-Dependent The RECORD_LENGTH parameter is used only when you will import on a machine with a different byte count of the file than on the machine where the export occurs. In most import sessions, the default should be used.
RECOVERY_TABLESPACES The RECOVERY_TABLESPACES, used in conjunction with the POINT_IN_TIME_RECOVER parameter, specifies which tablespaces may be recovered using Point-in-time Recovery. This is important because imports could not otherwise recover transactions past the time of export.
ROWS Y Specifies whether table and object data will be exported. If ROWS=N, only object definitions are exported.
STATISTICS ESTIMATE Specifies whether table and index statistics are to be analyzed with COMPUTE or ESTIMATE when imported. Note that only those objects that already have statistics on them will be analyzed during import. Specify NONE if no objects should be analyzed.
TABLES Specifies a comma-separated list of all tables to be exported. This parameter should be used in conjunction with the FROMUSER parameter. In a non-UNIX environment, such as Windows NT, you must enclose the table list within parentheses.

Page 314

Table 13.2Continued

Parameter Default Value Description TABLESPACES List of tablespaces to be exported with the POINT_IN_TIME_RECOVER parameter. USERID Specifies the username and password for the user conducting the import. The format for the command is username/password. You may also use Net8's @connect_string format if desired.

To use Import with the Interactive mode, just enter imp80 at the command line. You then receive a prompt for a username and password.

CAUTION
To use Import from a DBA-invoked export, the user account that you import with must have been granted the IMP_FULL_DATABASE system privilege. For accounts with DBA privileges such as SYSTEM, this privilege is implicitly granted to the user. Otherwise, the import will fail.

You then receive a prompt for the name of the export file from which to import. By default, it is expdat.dmp. Next, you receive a prompt for the array fetch buffer size. This is the size of the memory buffer through which rows are exported. This should be larger than the size of the largest record multiplied by the number of rows that you wish to fit within the buffer and is operating-system dependent.

Next, you are asked whether you want to list the contents of the import file only (Yes/No). The results if you select Yes are described later in this chapter in the section titled "Using the SHOW and INDEXFILE Options." If you select No, you are asked whether to ignore all create errors that may occur due to object existence (Yes/No). Then you are asked whether to import grants, table data, and the entire export file.

If you select No to import the entire export file, you receive a prompt for the username corresponding to the owner of the objects. This is followed by a repeating prompt to enter all tables and partitions. If you leave the line blank, all objects for the username are assumed. To stop the repeating prompt, enter a single period at the prompt.

To use Import in Non-interactive mode, you can either pass all parameters at the command line or through a parameter file. For all possible parameters of the import command, type imp80 help=y, as shown in Figure 13.2.

Page 315

FIG. 13.2
Sample output from
imp80 help=y on a
Windows NT platform.


You can use 24 parameters during an import session. You can specify them in either the command line or any parameter file that is specified. Table 13.3 describes all the import parameters.

Table 13.3Description of Parameters for the Import Utility

Parameter Default Value Description
ANALYZE Y Tables that are imported will have their statistics analyzed if ANALYZE is set to Y. Note that only those tables that already had statistics on them during the export will be computed. The tables will be ESTIMATEd by default, unless the export was performed with the STATISTICS=COMPUTE parameter configuration.
BUFFER OS-Dependent The size of BUFFER (in bytes) determines the memory buffer through which rows are imported. This should be larger than the size of the largest record multiplied by the number of rows that you wish to fit within the buffer.
                                              continues

Page 316

Table 13.3Continued

Parameter Default Value Description
CHARSET The CHARSET is an obsolete Oracle6 parameter, indicating whether the export was done in ASCII or EBCDIC. In Oracle7 and Oracle8, this information is processed automatically.
COMMIT N By default, a commit occurs after each table, nested table, and partition. If you are importing a large table, the rollback segments may grow large. To improve performance while loading large tables, you should set COMMIT=Y.
DESTROY N If you set DESTROY=Y and do a full import, Oracle overwrites any datafiles that exist. If you use raw devices for your datafiles, they will be overwritten during a full import because DESTROY=N will not prevent the overwriting of datafiles! It is always a good practice to back up the database before such an import. Do not use this option unless you know what you are doing.
FEEDBACK 0 Oracle displays a period for each group of records inserted. The size of the group is defined by FEEDBACK. By setting FEEDBACK=1000, for example, a period displays for every 1000 records imported. This parameter is useful for tracking the progress of large imports.
FILE expdat.dmp By default, expdat.dmp (stands for EXPort DATa.DuMP) is the name of the file that Import will import from. If the file is something other than expdat.dmp, specify it with the FILE parameter.
FROMUSER Specifying this parameter imports only those objects owned by the FROMUSER user account.

Previous | Table of Contents | Next