Using the EXP tables
The following data dictionary views can be used to identify which export file is required to restore a given table. The information is stored if the Export RECORD parameter is set to Y. See Chapter 16, for more details on specifying export parameters.
- DBA_EXP_FILES
This view has one row for each successful export since (and including) the last full export.
- DBA_EXP_OBJECTS
This view has one row for each exported object in the database. It specifies the last export version that contained that object.
- DBA_EXP_VERSION
This view has one row and one column, EXP_VERSION, which contains the last successful export.
By joining DBA_EXP_OBJECTS and DBA_EXP_FILES, you can locate the export file necessary to restore a given table. These data dictionary views are updated every time an export occurs. If you need historical information beyond the last time an object was exported, copy these data dictionary views into a permanent table.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
