Datapump - Revision history

Stuart: Stuart moved page Data Pump to Datapump

2018-12-04T10:43:02Z

Stuart moved page Data Pump to Datapump

Stuart: /* Change parallelism after expdp has started */

2018-10-01T13:56:10Z

‎Change parallelism after expdp has started

Stuart: /* Change parallelism after expdp has started */

2018-10-01T13:53:18Z

‎Change parallelism after expdp has started

Stuart: /* Monitor Data Pump sessions */

2018-10-01T13:50:40Z

‎Monitor Data Pump sessions

Stuart: /* Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX */

2018-08-27T12:43:18Z

‎Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX

Stuart: /* Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX */

2018-08-27T12:42:27Z

‎Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX

Stuart: /* Check the status of the job */

2018-08-27T12:41:59Z

‎Check the status of the job

Stuart: /* Check the status of the job */

2018-08-27T12:41:45Z

‎Check the status of the job

Stuart: /* Check the status of the job */

2018-08-27T12:41:30Z

‎Check the status of the job

Stuart: /* Find out what Datapump jobs are running */

2018-08-27T12:40:27Z

‎Find out what Datapump jobs are running

@@ Line 507: / Line 507: @@
    Dump File: /cln/tst/ora_data1/clnt/archivelog/clnt_tables_20180926.dmp
      bytes written: 73,117,818,880
 Worker 1 Status:
@@ Line 515: / Line 516: @@
    State: EXECUTING
    Object Schema: TPK
-   Object Name: EID01
+   Object Name: CCD01
    Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
-   Completed Objects: 5
+   Completed Objects: 10
    Total Objects: 192
-   Completed Rows: 847,418
+   Completed Rows: 317,968
    Worker Parallelism: 1
-Export> status
+Worker 2 Status:
    Instance ID: 1
    Instance name: clnt
    Host name: hn5306.cln.be
-   Process Name: DW00
+   Process Name: DW01
-   State: WORK WAITING
+   State: EXECUTING
+  Object Schema: TPK
-Worker 2 Status:
+  Object Name: BCD18
-   Instance ID: 0
+  Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
-   State: UNDEFINED
+  Completed Objects: 4
 Worker 3 Status:
@@ Line 551: / Line 541: @@
    Host name: hn5306.cln.be
    Process Name: DW02
-   State: WORK WAITING
+   State: EXECUTING
 Worker 4 Status:
-   Instance ID: 0
+   Instance ID: 1
-   State: UNDEFINED
+  Instance name: clnt
 Export>

@@ Line 443: / Line 443: @@
 Export started with 1 worker but taking a long time? Change the number of parallel workers!
 <pre>
-(1) crelant oracle@hn5306:/crelan/tst/ora_data1/common/keep> expdp \'\/ as sysdba\' attach=SYS_EXPORT_TABLE_01
+expdp \'\/ as sysdba\' attach=SYS_EXPORT_TABLE_01
 Export: Release 12.1.0.2.0 - Production on Mon Oct 1 15:44:41 2018
@@ Line 468: / Line 468: @@
    EXPORT Job Parameters:
    Parameter Name      Parameter Value:
-      CLIENT_COMMAND        /******** AS SYSDBA parfile=/oracle/scripts/expdp_crelant_tables.par
+      CLIENT_COMMAND        /******** AS SYSDBA parfile=/oracle/scripts/expdp_clnt_tables.par
    State: EXECUTING
    Bytes Processed: 73,116,744,528
@@ Line 474: / Line 474: @@
    Current Parallelism: 1
    Job Error Count: 0
-   Dump File: /crelan/tst/ora_data1/crelant/archivelog/crelant_tables_20180926.dmp
+   Dump File: /cln/tst/ora_data1/clnt/archivelog/clnt_tables_20180926.dmp
      bytes written: 73,117,818,880
 Worker 1 Status:
    Instance ID: 1
-   Instance name: crelant
+   Instance name: clnt
-   Host name: hn5306.crelan.be
+   Host name: hn5306.cln.be
    Process Name: DW00
    State: EXECUTING
@@ Line 505: / Line 505: @@
    Current Parallelism: 4
    Job Error Count: 0
-   Dump File: /crelan/tst/ora_data1/crelant/archivelog/crelant_tables_20180926.dmp
+   Dump File: /cln/tst/ora_data1/clnt/archivelog/clnt_tables_20180926.dmp
      bytes written: 73,117,818,880
 Worker 1 Status:
    Instance ID: 1
-   Instance name: crelant
+   Instance name: clnt
-   Host name: hn5306.crelan.be
+   Host name: hn5306.cln.be
    Process Name: DW00
    State: EXECUTING
@@ Line 532: / Line 532: @@
    Current Parallelism: 4
    Job Error Count: 0
-   Dump File: /crelan/tst/ora_data1/crelant/archivelog/crelant_tables_20180926.dmp
+   Dump File: /cln/tst/ora_data1/clnt/archivelog/clnt_tables_20180926.dmp
      bytes written: 83,668,553,728
 Worker 1 Status:
    Instance ID: 1
-   Instance name: crelant
+   Instance name: clnt
-   Host name: hn5306.crelan.be
+   Host name: hn5306.cln.be
    Process Name: DW00
    State: WORK WAITING
@@ Line 548: / Line 548: @@
 Worker 3 Status:
    Instance ID: 1
-   Instance name: crelant
+   Instance name: clnt
-   Host name: hn5306.crelan.be
+   Host name: hn5306.cln.be
    Process Name: DW02
    State: WORK WAITING

@@ Line 439: / Line 439: @@
   DIRECTORY=expdp_dir
   PARALLEL=8
 ===Monitor Data Pump sessions===

@@ Line 239: / Line 239: @@
 select * from dba_datapump_jobs;
 </pre>
-Check to see if the impdp session is waiting for resources
+====Check to see if the impdp session is waiting for resources====
 <pre>
 select vsw.*
@@ Line 249: / Line 249: @@
+/
 </pre>
-Check dba_resumable for data pump jobs
+====Check dba_resumable for data pump jobs====
 <pre>
 select * from dba_resumable;
 </pre>
-Check alert log for possible error/warning messages.
+====Check alert log for possible error/warning messages====
 ===Find out what Datapump jobs are running===

@@ Line 234: / Line 234: @@
 ===Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX===
 Import is taking a long time and stuck on this line. Is it waiting for something or just slow?<br />
-Datapunp does not import indexes, it recreates them using create index statements. This can be slow, especially as all the metadata uses just 1 worker.
+Datapump does not import indexes, it recreates them using create index statements. This can be slow, especially as all the metadata uses just 1 worker.
 ====Check the status of the job====
 <pre>

← Older revision	Revision as of 10:43, 4 December 2018
(No difference)

@@ Line 246: / Line 246: @@
 ,      v$session_wait vsw
 where  dds.saddr = vs.saddr
-and     vs.sid   = vsw.sid
+and    vs.sid    = vsw.sid
+/
 </pre>

@@ Line 231: / Line 231: @@
 logfile=import_DWH_TABLES.log
 </pre>
 ===Find out what Datapump jobs are running===
@@ Line 260: / Line 283: @@
 SQL>
 </pre>
 ===Kill a datapump job with PL/SQL===
 <pre>