问题现象: 最近一用户准备搭建测试环境,由于该用户正式库是AIX小机,测试环境是X86平台,因此只能通过expdp进行数据导出,但是在导出的时候,发现EXPDP一直卡在如下位置,几个小时都不动弹: Export: Release 11.2.0.3.0 - Production on Fri Dec 5 13:06:2
问题现象:
最近一用户准备搭建测试环境,由于该用户正式库是AIX小机,测试环境是X86平台,因此只能通过expdp进行数据导出,但是在导出的时候,发现EXPDP一直卡在如下位置,几个小时都不动弹:
Export: Release 11.2.0.3.0 - Production on Fri Dec 5 13:06:21 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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** dumpfile=dump:full20141204b_%U_db.dmp logfile=dump:full_expdp1204b_db.log full=y exclude=PACKAGE,FUNCTION,PROCEDURE,INDEX,TABLE:"IN (select table_name
from
dba_tables where table_name in ('电子病历图形','检验图像结果','检验报告图像') and owner='ZLHIS')" cluster=n TRACE=480300
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 125.3 GB
Proc