SQL> SELECT directory_name, directory_path FROM dba_directories;
SQL> SELECT owner_name, job_name, operation, job_mode FROM dba_datapump_jobs; ----------------------------------- SYSTEM EXP_BEFLYDBA_FULL
SQL> DROP TABLE EXP_BEFLYDBA_FULL; TABLE dropped.
SQL> SELECT 'DROP TABLE '||OWNER||'.'||TABLE_NAME||';' SQL FROM DBA_TABLES WHERE TABLE_NAME LIKE '%SYS%EXPORT%'; SQL ------------------------------------------------------------------------- DROP TABLE SYSTEM.SYS_EXPORT_FULL_01;
SQL> DROP TABLE SYSTEM.SYS_EXPORT_FULL_01;