oracle一直卡在跟新库,expdp的时候一直卡在那 咋办???

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值