Friday, November 28, 2008

DBA_EXP_VERSION

DBA_EXP_VERSION displays the version number of the last export session.

Column

Datatype

NULL

Description

EXP_VERSION

NUMBER(3)

NOT NULL

Version number of the last 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