- Concurrent Index Creation
Oracle uses serial index creation in datapump import and bogs down. Overcome slow index creation in impdp with concurrent index creation tool. Runs in Cygwin.
in Oracle > Utilities with and bogs concurrent creation cygwin. datapump down. impdp import in index oracle overcome runs serial slow tool. uses with
- 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
- Oracle: How to Extract schema and Tablespace DDL's using Datapump SQLFILE parameter
How to Extract schema and Tablespace DDL's using Datapump SQLFILE parameter
in Oracle > DB 11g with datapump ddls extract impdp parameter sqlfile tablespace
- Making consistent datapump exports in 11g
Consistent datapump exports
in Oracle > DB 11g with consistent datapump expdp export flashback
- 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
datapump from all users