V$ tables for EXPORT/IMPORT

[rpardip]

What DBA views/V$ tables contain information about EXPORT, IMPORT, and the type of export (INC, CUM, FULL) performed on the DB ?


Thanks in advance!

[yumi_rama]

As far as i know of, there is no view or table for export, as it is a Oracle Utility, it does generate a log file, in the same dir, usually Oracle_home\bin. You could check the log file for the info. you wnat to know.

Rama

[jdorlon]

actually there are 3 views which contain information about recent exports. They are :

DBA_EXP_FILES
DBA_EXP_OBJECTS
DBA_EXP_VERSION

These only contain information when you use the INCTYPE parameter in your exports.

-John

[rpardip]

Thanks John!