DBA_EXP_OBJECTS
describes objects that have been incrementally exported.
Column | Datatype | NULL | Description |
|
|
| Owner of exported object |
|
|
| Name of exported object |
|
| | Type of exported object |
|
| | Timestamp of last cumulative export |
|
|
| Timestamp of last incremental export |
|
|
| 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