First page Back Continue Last page Graphics
Data Pump Dictionary
Monitor job progress
- V$SESSION_LONGOPS
- DBA_DATAPUMP_JOBS
- DBA_DATAPUMP_SESSIONS
Valid objects for INCLUDE parameter
- DATABASE_EXPORT_OBJECTS
- SCHEMA_EXPORT_OBJECTS
- TABLE_EXPORT_OBJECTS.
Notes:
Several dictionary views (many are new) are helpful when using datapump:
V$SESSION_LONGOPS – Datapump jobs record their progress in V$SESSION_LONGOPS so that you can see how far along the job is.
DBA_DATAPUMP_JOBS – Active datapump jobs show up here. You can see the owner, job name, operation and more. Even if the job is halted (STATE=“NOT RUNNING”), it will be recorded here.
DBA_DATAPUMP_SESSIONS – This shows who is currently connected to a job.
The INCLUDE parameter is very powerful, but that means some complexity. The list of objects that can be specified in the INCLUDE command are vast enough to warrant database tables to hold them. That is what is in the *_EXPORT_OBJECTS views.