Oracle7 Server Utilities

Contents Index Home Previous Next

Export Parameters

The parameters listed below can be specified in the parameter file. They are described in detail in the remainder of this section.

USERID RECORDLENGTH
BUFFER INCTYPE
FILE RECORD
GRANTS HELP
INDEXES LOG
ROWS CONSISTENT
CONSTRAINTS STATISTICS
COMPRESS FEEDBACK
FULL MLS*
OWNER MLS_LABEL_FORMAT*
TABLES
*Trusted Oracle7 Server parameter
BUFFER

Default: operating system dependent

The parameter BUFFER determines the maximum number of rows in an array fetched by Export by specifying the size of the buffer. You can calculate the buffer size as follows:

buffer_size = rows_in_array * maximum_row_size

buffer_size is the size in bytes of the buffer into which data rows are fetched. If zero is specified, or if rows contain LONG data, only one row at a time is fetched.

Additional Information: See your Oracle operating system-specific documentation to determine the default value for this parameter.

COMPRESS

Default: Y

Specifies how Export/Import will manage the initial extent for table data.

The default, COMPRESS=Y, causes Export to flag the table data for consolidation into one initial extent upon Import.

If COMPRESS=N is specified, Export will sum the lengths of all current extents on export and Import will use that value as the size of the initial extent for the imported table data. Note that, when a table has had many deletes, this size may be much larger than the table actually requires.

Note: Although used extents are consolidated into one extent upon import, you must request consolidation when exporting, because your request causes the table definition to be exported differently. Thus, if you request consolidation when exporting, you can import the data in consolidated form only.

CONSISTENT

Default: N

Specifies whether Export will use the SET TRANSACTION READ ONLY statement to insure that the export is consistent to a single point in time. Specifying CONSISTENT=Y is important when other applications will be updating the database after an export has started because these transactions will be rolled back, if necessary.

If you specify CONSISTENT=Y, a rollback segment must be retained for the duration of the export to allow backing out of the effects of any uncommitted transactions when a table is exported. Note that, if the volume of updates is large, the rollback segment will itself be large. In addition, the export of each table will be slower, since the rollback segment must be scanned for uncommitted transactions.

Note: CONSISTENT cannot be used with an incremental export.

Suggestion: To minimize the time and space required for such exports, tables that need to remain consistent should be exported separately from those that do not.

For example, export the EMP and DEPT tables together in a consistent export, then export the remainder of the database in a second pass.

Exporting the minimum number of objects that must be guaranteed consistent helps to reduce the chances of encountering a "snapshot too old" error.

This error occurs when rollback space has been used up, and space taken up by committed transactions is reused for new transactions. Reusing space in the rollback segment allows database integrity to be preserved with minimum space requirements, but it imposes a limit on the amount of time that a read-consistent image can be preserved.

If a committed transaction has been overwritten and the information is needed for a read-consistent view of the database, then a "snapshot too old" error results.

To avoid this error, minimize the time taken by a read-consistent export (by restricting the number of objects exported and, if possible, by reducing the database transaction rate). Also, make the rollback segment as large as possible.

CONSTRAINTS

Default: Y

A flag to indicate whether to export table constraints.

DIRECT

Default: N

Specifying DIRECT=Y causes export to extract data by reading the data directly, bypassing the SQL Command Processing layer (evaluating buffer). This method can be much faster than a conventional path export.

Performance can also be improved by using direct path export with the database in direct read mode. Contention for resources with other users is eliminated because database blocks are read into the private buffer cache, rather than a public buffer cache.

For more information about direct path exports, see [*].

FEEDBACK

Default: 0 (zero)

Specifies that Export should display a progress meter in the form of a dot for x number of rows exported. For example, were you to specify FEEDBACK=10, Export would display a dot each time 10 rows had been exported. The FEEDBACK value applies to all tables being exported, it cannot be set on a per table basis.

FILE

Default: EXPDAT.DMP

The name of the export file. The default extension is .DMP, but you can specify any extension.

FULL

Default: N

Specifies whether Export should export the entire database or not. Specify FULL=Y to export in full database mode (you must have the EXP_FULL_DATABASE role enabled to do this).

GRANTS

Default: Y

Specifies whether grants should be exported or not.

HELP

Default: N

Displays a help message with descriptions of the Export parameters.

INCTYPE

Default: none

Specifies the type of incremental export. Options are COMPLETE, CUMULATIVE, and INCREMENTAL. See the section in this chapter called "Incremental, Cumulative and Complete Exports" for a description of these options.

INDEXES

Default: Y

Specifies whether indexes should be exported or not.

LOG

Default: none

Specifies a file name to receive informational and error messages. For example:

EXP system/manager LOG=export.log

If this parameter is specified, messages are logged in the log file and displayed via the terminal display.

MLS

The Export utility can be used on any Trusted Oracle7 database to produce a normal export file. In DBMS Mandatory Access Control (MAC) mode, the MLS parameter can also be specified. With this parameter, the Multi-Level Security (MLS) labels on each row and object in the database are included in the export file. This parameter is further described in the Trusted Oracle7 Server Administrator's Guide.

MLS_LABEL_ FORMAT

This parameter allows you to override the default format specified in the database for human-readable MLS labels. The format you specify will be used in the export file instead of the format defined by the database initialization parameter. This parameter is further described in the Trusted Oracle7 Server Administrator's Guide.

OWNER

Default: undefined

Specifies a list of usernames whose objects will be exported. Specify OWNER=userlist to export in user mode.

RECORD

Default: Y

A flag to indicate whether to record an incremental or cumulative export in database tables SYS.INCVID, SYS.INCFIL, and SYS.INCEXP. See [*].

RECORDLENGTH

Default: operating system dependent

Specifies the length, in bytes, of the file record. The RECORDLENGTH parameter is necessary when you must transfer the export file to another operating system that uses a different default value.

Additional Information: See your Oracle operating system-specific documentation for the system being exported to determine the proper value, or when you want to create a file with a different record size.

ROWS

Default: Y

Specifies whether the rows of table data should be exported or not.

STATISTICS

Default: ESTIMATE

Specifies the type of database optimizer statistics to generate when the exported data is imported later. Options are ESTIMATE, COMPUTE, and NONE. See Chapter 13 of the Oracle7 Server Concepts manual for information about the optimizer.

TABLES

Default: undefined

Specifies list of table names to export. Specify TABLES=tablelist to export in table mode.

Storage Parameters: Tables are exported using the current storage parameters. Unless ALTER TABLE command has been executed to change them, these are the parameters in effect when the tables were created.

USERID

Default: none

Specifies the username/password of the user initiating the export.

Parameter Interactions

Certain parameters can conflict with each other. For example, specifying TABLES can conflict with an OWNER specification, the following command will cause Export to terminate with an error:

EXP system/manager OWNER=jones TABLES=scott.emp

Similarly, OWNER conflicts with FULL=Y.

Although ROWS=N and INCTYPE=INCREMENTAL can both be used, specifying ROWS=N (no data) defeats the purpose of incremental exports, which is to make a backup copy of tables that have changed.


Contents Index Home Previous Next