Friday, November 28, 2008

DBA_EXP_OBJECTS

DBA_EXP_OBJECTS describes objects that have been incrementally exported.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of exported object

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Name of exported object

OBJECT_TYPE

VARCHAR2(12)

Type of exported object

CUMULATIVE

DATE

Timestamp of last cumulative export

INCREMENTAL

DATE

NOT NULL

Timestamp of last incremental export

EXPORT_VERSION

NUMBER(3)

NOT NULL

The ID 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