- Data Pump - How to avoid exporting/importing jobs
SELECT named, object_path, comments FROM schema_export_objects WHERE object_path LIKE 'JOB%' Named Object_path Comments NULL JOB Jobs in the selected schemas. If the Named column=Y, you can exclude the object type and if its null,you cannot.
in Oracle > DB 11g with database database_export_objects datapump exclude expdp export job named null schema schema_export_objects table table_export_objects
- DataPump Oracle Docs 11.1
Nitty gritty on the API for Sql scripts, PL/SQL for running import/export, for example METADATA_REMAP
in Oracle > Utilities with api application datapump dbms dbms_datapump expdp export impdp import interface metadata_filter metadata_remap of package program programmatic remap_tablespace subprograms summary
Note: move all or parts of a database between databases, superseding -- functionality previously associated with the Export and Import utilities -- (which will now rely on the dbms_datapump interface). Dbms_datapump will -- also support the loading and unloading of data in a proprietary format.
- Kill, cancel and resume or restart datapump expdp and impdp jobs – Oracle 48
Kill, cancel and resume or restart datapump expdp and impdp jobs
in Oracle > Utilities with cancel datapump expdp impdp jobs kill restart resume start stop
- Programming Oracle Data Pump
Data Pump Programming with Oracle 10g 11g 11gR2 DBMS_DATAPUMP
in Oracle > DB 11g with 10g 11g 11gr2 add_file data dbms_datapump detach expdp export handle job metadata_filter oracle programming pump with
- Making consistent datapump exports in 11g
Consistent datapump exports
in Oracle > DB 11g with consistent datapump expdp export flashback
- ORACLE-BASE
Oracle Data Pump (expdp and impdp) in Oracle Database 10g
in Oracle > Utilities with database expdp impdp oracle pump syntax
- ORACLE-BASE data pump wizards in SQL Developer
SQL Developer 3.1 Data Pump Wizards (expdp, impdp)
in Oracle > Utilities with database datapump expdp export impdp integration oracle pump sql sqldeveloper wizards
expdp from all users