Friday, November 28, 2008

DBA_EXP_FILES

DBA_EXP_FILES describes export files.

Column

Datatype

NULL

Description

EXP_VERSION

NUMBER(3)

NOT NULL

Version number of the export session

EXP_TYPE

VARCHAR2(11)

Type of export file: complete, cumulative, or incremental

FILE_NAME

VARCHAR2(100)

NOT NULL

Name of the export file

USER_NAME

VARCHAR2(30)

NOT NULL

Name of user who executed export

TIMESTAMP

DATE

NOT NULL

Timestamp of the export session

Note:

1. The DBA_EXP views are only used with incremental exports.

To use the DBA_EXP views to track exports, use the incremental option. Use SYS.INCEXP, SYS.INCFIL, and SYS.INCVID tables to get information regarding table, user, and full exports.

If you are doing an incremental export, and the DBA_EXP views are empty, ensure that the Export parameter RECORD has been set to Y. RECORD controls whether or not entries are made to these tables during incremental exports. The default value for RECORD is Y, but if it has been changed to N you could see this problem on an incremental export.

2. Related views:

DBA_EXP_FILES

DBA_EXP_OBJECTS

DBA_EXP_VERSION

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment