Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Expdp and impdp

974882Oct 1 2013 — edited Oct 1 2013

Hi ,

I am doing export of full database with parallel=8 syntax but while checking through status its showing only one. ....Pls suggest.

Also one more point, if my putty session get closed, do my export job get terminiated . I suppose not ..Pls suggest.

Export> status

Job: EXPORT_EBP
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /dbexport/export/export_FULL_01.dmp
bytes written: 4,096
Dump File: /dbexport/export/export_FULL_%u.dmp

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: SAPDAT
Object Name: /BI0/F0PA_C01
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 24,000
Worker Parallelism: 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2013

Added on Oct 1 2013

#database-key-features, #export-import-sql-loader-external-tables

6 comments

1,034 views