oracle@stageip1:/export/oracle > expdp \'/ as sysdba\' ATTACH=SYS_EXPORT_SCHEMA_01
Export: Release 11.2.0.3.0 - Production on Wed Jul 16 04:08:47 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
Job: SYS_EXPORT_SCHEMA_01
Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: FE4BC1243582594BE044002128A3C4CC
Start Time: Wednesday, 16 July, 2014 2:48:52
Mode: SCHEMA
Instance: iris
Max Parallelism: 8
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND "/******** AS SYSDBA" FLASHBACK_SCN=137239089 schemas=COGNOSOWNER,HEALTHOWNER,ISAOWNER,ITAOWNER,IRISOWNER directory=IRIS_MOVE parallel=8 compression=ALL REUSE_DUMPFILES=y dumpfile=Iris_U.dmp logfile=expdpIris.log
COMPRESSION ALL
FLASHBACK_SCN 82E1A31
State: EXECUTING
Bytes Processed: 34,579,096
Percent Done: 56
Current Parallelism: 8
Job Error Count: 0
Dump File: /export/oracle/datadump/Iris_U.dmp
bytes written: 36,155,392
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: COGNOSOWNER
Object Name: TIMESTAMP_DIFF_IN_SECONDS
Object Type: SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Completed Objects: 1
Total Objects: 1
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: EXECUTING
Object Schema: IRISOWNER
Object Name: PARTITION_MANAGEMENT
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 23
Total Objects: 78,567
Worker Parallelism: 1
Worker 3 Status:
Process Name: DW02
State: WORK WAITING
Worker 4 Status:
Process Name: DW03
State: WORK WAITING
Worker 5 Status:
Process Name: DW04
State: WORK WAITING
Worker 6 Status:
Process Name: DW05
State: EXECUTING
Object Schema: HEALTHOWNER
Object Name: PROBESIZINGRULE
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 107
Total Objects: 78,567
Worker Parallelism: 1
Worker 7 Status:
Process Name: DW06
State: WORK WAITING
Worker 8 Status:
Process Name: DW07
State: EXECUTING
Object Schema: IRISOWNER
Object Name: CONF_POLICY_PROFILE_TO_USER
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 123
Total Objects: 78,567
Worker Parallelism: 1