dbdao吧 关注:1,183贴子:4,074
  • 15回复贴,共1

AIX oracle 11.2.0.3 expdp 导出分区表时卡住

只看楼主收藏回复

刘大,你好,我遇到以下问题,求助!
AIX oracle 11.2.0.3 expdp 导出分区表时卡住,一直处在以下界面,status查看一直在处理对象,但是很慢,schema下有45张表,表分区有1万5千多

用exp能正常导出
这是什么原因呐?


1楼2015-12-23 19:58回复
    当表上数据并不多,但是相关对象 例如分区很多时 使用exp 确实可以加快速度。
    但当数据量也很大时 则仍能从expdp中得益。你可以具体trace下 expdp在做什么,同时这类问题 至少 把expdp 的命令贴全,这是最基本的


    2楼2015-12-23 23:05
    回复
      2025-12-26 15:40:55
      广告
      不感兴趣
      开通SVIP免广告
      刘大,辛苦!
      我重新测试了下
      ============================表分区信息如下============================
      select count(*) from dba_tab_partitions where table_owner='TT'
      count(*)
      15615
      select count(*) from dba_tab_subpartitions where table_owner='TT'
      count(*)
      765135
      ===========================EXPDP============================================
      expdp system/passwd directory=dump_dir dumpfile=TT_20151224_%U.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no parallel=8 compression=all trace=480300
      Export: Release 11.2.0.3.0 - Production on Thu Dec 24 09:18:37 2015
      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
      FLASHBACK automatically enabled to preserve database integrity.
      Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224_%U.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no parallel=8
      Estimate in progress using BLOCKS method...
      Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
      Export> status
      Job: EXPDP_TT_JOB
      Operation: EXPORT
      Mode: SCHEMA
      State: EXECUTING
      Bytes Processed: 0
      Current Parallelism: 8
      Job Error Count: 0
      Dump File: /app/backup/temp/TT_20151224_01.dmp
      bytes written: 4,096
      Dump File: /app/backup/temp/TT_20151224_%u.dmp
      Worker 1 Status:
      Process Name: DW00
      State: EXECUTING
      Object Schema: TT
      Object Name: TT_208
      Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
      Completed Objects: 146,000
      Worker Parallelism: 1
      Export> status
      Job: EXPDP_TT_JOB
      Operation: EXPORT
      Mode: SCHEMA
      State: EXECUTING
      Bytes Processed: 0
      Current Parallelism: 8
      Job Error Count: 0
      Dump File: /app/backup/temp/TT_20151224_01.dmp
      bytes written: 4,096
      Dump File: /app/backup/temp/TT_20151224_%u.dmp
      Worker 1 Status:
      Process Name: DW00
      State: EXECUTING
      Object Schema: TT
      Object Name: TT_208
      Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
      Completed Objects: 148,960
      Worker Parallelism: 1
      Export> status
      Job: EXPDP_TT_JOB
      Operation: EXPORT
      Mode: SCHEMA
      State: EXECUTING
      Bytes Processed: 0
      Current Parallelism: 8
      Job Error Count: 0
      Dump File: /app/backup/temp/TT_20151224_01.dmp
      bytes written: 4,096
      Dump File: /app/backup/temp/TT_20151224_%u.dmp
      Worker 1 Status:
      Process Name: DW00
      State: EXECUTING
      Object Schema: TT
      Object Name: TT_208
      Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
      Completed Objects: 152,000
      Worker Parallelism: 1
      Export> status
      Job: EXPDP_TT_JOB
      Operation: EXPORT
      Mode: SCHEMA
      State: EXECUTING
      Bytes Processed: 0
      Current Parallelism: 8
      Job Error Count: 0
      Dump File: /app/backup/temp/TT_20151224_01.dmp
      bytes written: 4,096
      Dump File: /app/backup/temp/TT_20151224_%u.dmp
      Worker 1 Status:
      Process Name: DW00
      State: EXECUTING
      Object Schema: TT
      Object Name: TT_302
      Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
      Completed Objects: 188,000
      Worker Parallelism: 1
      Export> status
      Job: EXPDP_TT_JOB
      Operation: EXPORT
      Mode: SCHEMA
      State: EXECUTING
      Bytes Processed: 0
      Current Parallelism: 8
      Job Error Count: 0
      Dump File: /app/backup/temp/TT_20151224_01.dmp
      bytes written: 4,096
      Dump File: /app/backup/temp/TT_20151224_%u.dmp
      Worker 1 Status:
      Process Name: DW00
      State: EXECUTING
      Object Schema: TT
      Object Name: TT_103
      Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
      Completed Objects: 254,000
      Worker Parallelism: 1
      Export> status
      Job: EXPDP_TT_JOB
      Operation: EXPORT
      Mode: SCHEMA
      State: EXECUTING
      Bytes Processed: 0
      Current Parallelism: 8
      Job Error Count: 0
      Dump File: /app/backup/temp/TT_20151224_01.dmp
      bytes written: 4,096
      Dump File: /app/backup/temp/TT_20151224_%u.dmp
      Worker 1 Status:
      Process Name: DW00
      State: EXECUTING
      Object Schema: TT
      Object Name: TT_201
      Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
      Completed Objects: 256,000
      Worker Parallelism: 1
      Export>
      一直缓慢进行,就算一晚上过去还是这个状态......


      3楼2015-12-24 12:55
      回复
        =============================TRACE=====================================
        System name: AIX
        Node name: DB1
        Release: 1
        Version: 7
        Machine:
        Instance name: node1
        Redo thread mounted by this instance: 1
        Oracle process number: 228
        Unix process pid: 22676206, image: oracle@DB1 (DM00)
        *** 2015-12-24 09:18:43.132
        *** SESSION ID:(498.8381) 2015-12-24 09:18:43.132
        *** CLIENT ID:() 2015-12-24 09:18:43.132
        *** SERVICE NAME:(SYS$USERS) 2015-12-24 09:18:43.132
        *** MODULE NAME:(Data Pump Master) 2015-12-24 09:18:43.132
        *** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 09:18:43.132
        KUPC: Setting remote flag for this process to FALSE
        prvtaqis - Enter
        prvtaqis subtab_name upd
        prvtaqis sys table upd
        KUPP: Initialization complete for master process DM00
        *** 2015-12-24 09:18:44.273
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656144 lascn 22
        *** 2015-12-24 09:18:46.098
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656144 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 09:18:46.726
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257654983 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656144 lascn 22
        *** 2015-12-24 09:30:21.802
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656144 lascn 22
        kwqberlst !retval block
        *** 2015-12-24 09:49:42.929
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 09:49:47.822
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 09:50:07.283
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 09:50:28.695
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 09:54:38.869
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 09:54:42.299
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 10:03:05.511
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 10:03:21.178
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 12:19:21.934
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        *** 2015-12-24 12:26:42.559
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst !retval block
        kwqberlst rqan->lagno_kwqiia 8
        kwqberlst rqan->lascn_kwqiia > 0 block
        kwqberlst rqan->lascn_kwqiia 8
        kwqberlst ascn -257656164 lascn 22
        ===================================EXP======================================
        exp system/passwd file=/app/backup/temp/TT_20151223.dmp log=/app/backup/temp/TT_20151223.log OWNER=TT
        导出大小:64G
        导出时间:8小时
        未能分析出原因所在!


        4楼2015-12-24 12:57
        回复
          parallel=8 compression=all
          关掉并行和 压缩试试


          5楼2015-12-24 14:38
          回复
            测试 签名


            6楼2015-12-24 16:29
            回复
              关掉并行有日志显示,搜集table,partition,subpartition信息:
              expdp system/passwd directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
              Export: Release 11.2.0.3.0 - Production on Thu Dec 24 09:18:37 2015
              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
              FLASHBACK automatically enabled to preserve database integrity.
              Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
              Estimate in progress using BLOCKS method...
              Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
              Export> status
              Job: EXPDP_TT_JOB
              Operation: EXPORT
              Mode: SCHEMA
              State: EXECUTING
              Bytes Processed: 0
              Current Parallelism: 1
              Job Error Count: 0
              Dump File: /app/backup/temp/TT_20151224.dmp
              bytes written: 4,096
              Worker 1 Status:
              Process Name: DW00
              State: EXECUTING
              Object Schema: TT
              Object Name: TT_209
              Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
              Completed Objects: 160,000
              Worker Parallelism: 1
              Export> status
              Job: EXPDP_TT_JOB
              Operation: EXPORT
              Mode: SCHEMA
              State: EXECUTING
              Bytes Processed: 0
              Current Parallelism: 1
              Job Error Count: 0
              Dump File: /app/backup/temp/TT_20151224.dmp
              bytes written: 4,096
              Worker 1 Status:
              Process Name: DW00
              State: EXECUTING
              Object Schema: TT
              Object Name: TT_302
              Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
              Completed Objects: 194,000
              Worker Parallelism: 1


              7楼2015-12-24 16:30
              回复
                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
                ORACLE_HOME = /app/oracle/product/11.2.0/db_1
                System name: AIX
                Node name: DB1
                Release: 1
                Version: 7
                Machine:
                Instance name: node1
                Redo thread mounted by this instance: 1
                Oracle process number: 729
                Unix process pid: 9765324, image: oracle@DB1 (DW00)
                *** 2015-12-24 14:54:08.646
                *** SESSION ID:(2971.10545) 2015-12-24 14:54:08.646
                *** CLIENT ID:() 2015-12-24 14:54:08.646
                *** SERVICE NAME:(SYS$BACKGROUND) 2015-12-24 14:54:08.646
                *** MODULE NAME:() 2015-12-24 14:54:08.646
                *** ACTION NAME:() 2015-12-24 14:54:08.646
                KUPP:14:54:08.639: Current trace/debug flags: 00480300 = 4719360
                *** MODULE NAME:(Data Pump Worker) 2015-12-24 14:54:08.646
                *** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 14:54:08.646
                KUPW:14:54:08.646: 0: ALTER SESSION ENABLE PARALLEL DML called.
                KUPW:14:54:08.646: 0: ALTER SESSION ENABLE PARALLEL DML returned.
                *** 2015-12-24 14:54:08.668
                KUPC:14:54:08.668: Setting remote flag for this process to FASSE
                prvtaqis - Enter
                prvtaqis subtab_name upd
                prvtaqis sys table upd
                KUPW:14:54:08.758: 0: KUPP$PROC.WHATS_MY_ID called.
                KUPW:14:54:08.758: 1: KUPP$PROC.WHATS_MY_ID returned.
                KUPW:14:54:08.759: 1: worker max message number: 1000
                KUPW:14:54:08.761: 1: Cluster access disabled - all workers and slaves local
                KUPW:14:54:08.762: 1: Original job start time: 15-DEC-24 02:54:07 PM
                KUPW:14:54:08.765: 1: Seqno 63 is SCHEMA_EXPORT/TABLE/TABLE_DATA
                KUPW:14:54:08.765: 1: Seqno 243 is SCHEMA_EXPORT/TABLE/INDEX/TABLE_DATA
                KUPW:14:54:08.765: 1: KUPP$PROC.WHATS_MY_NAME called.
                KUPW:14:54:08.765: 1: KUPP$PROC.WHATS_MY_NAME returned. Process name: DW00
                KUPW:14:54:08.765: 1: KUPV$FT_INT.GET_INSTANCE_ID called.
                KUPW:14:54:08.765: 1: KUPV$FT_INT.GET_INSTANCE_ID returned. Instance name: SCDB1:gzsthxzg1
                KUPW:14:54:08.767: 1: ALTER SESSION ENABLE RESUMABLE called.
                KUPW:14:54:08.768: 1: ALTER SESSION ENABLE RESUMABLE returned.
                KUPW:14:54:08.769: 1: KUPF$FILE.INIT called.
                KUPW:14:54:08.784: 1: KUPF$FILE.INIT returned.
                KUPW:14:54:08.787: 1: KUPF$FILE.GET_MAX_CSWIDTH called.
                KUPW:14:54:08.787: 1: KUPF$FILE.GET_MAX_CSWIDTH returned.
                KUPW:14:54:08.787: 1: Max character width: 4
                KUPW:14:54:08.787: 1: Max clob fetch: 8181
                KUPW:14:54:08.787: 1: Max varchar2a size: 8181
                KUPW:14:54:08.787: 1: Max varchar2 size: 1990
                KUPW:14:54:08.787: 1: In procedure GET_PARAMETERS
                KUPW:14:54:08.789: 1: In procedure GET_METADATA_FILTERS
                KUPW:14:54:08.790: 1: In procedure GET_METADATA_TRANSFORMS
                KUPW:14:54:08.791: 1: In procedure GET_DATA_FILTERS
                KUPW:14:54:08.792: 1: In procedure GET_DATA_REMAPS
                KUPW:14:54:08.792: 1: In procedure PRINT_MT_PARAMS
                KUPW:14:54:08.792: 1: Master table : "SYSTEM"."EXPDP_TT_JOB"
                KUPW:14:54:08.792: 1: Metadata job mode : SCHEMA_EXPORT
                KUPW:14:54:08.792: 1: Debug enable : TRUE
                KUPW:14:54:08.792: 1: Profile enable : FASSE
                KUPW:14:54:08.792: 1: Transportable enable : FASSE
                KUPW:14:54:08.792: 1: Metrics enable : FASSE
                KUPW:14:54:08.793: 1: db version : 11.2.0.3.0
                KUPW:14:54:08.793: 1: job version : 11.2.0.0.0
                KUPW:14:54:08.793: 1: service name :
                KUPW:14:54:08.793: 1: Current Edition : ORA$BASE
                KUPW:14:54:08.793: 1: Job Edition :
                KUPW:14:54:08.793: 1: Abort Step : 0
                KUPW:14:54:08.793: 1: Access Method : AUTOMATIC
                KUPW:14:54:08.793: 1: Data Options : 0
                KUPW:14:54:08.793: 1: Dumper directory :
                KUPW:14:54:08.793: 1: Master only : FASSE
                KUPW:14:54:08.793: 1: Data Only : FASSE
                KUPW:14:54:08.793: 1: Metadata Only : FASSE
                KUPW:14:54:08.793: 1: Estimate : BLOCKS
                KUPW:14:54:08.793: 1: Data error logging table :
                KUPW:14:54:08.793: 1: Remote Link :
                KUPW:14:54:08.793: 1: Dumpfile present : TRUE
                KUPW:14:54:08.793: 1: Table Exists Action :
                KUPW:14:54:08.793: 1: Partition Options : NONE
                KUPW:14:54:08.793: 1: Tablespace Datafile Count: 0
                KUPW:14:54:08.793: 1: Metadata Filter Index : 1 Count : 8
                KUPW:14:54:08.793: 1: 1 Name - INCLUDE_USER
                KUPW:14:54:08.793: 1: Value - TRUE
                KUPW:14:54:08.793: 1: Object Name - SCHEMA_EXPORT
                KUPW:14:54:08.793: 1: 2 Name - SCHEMA_EXPR
                KUPW:14:54:08.793: 1: Value - IN ('TT')
                KUPW:14:54:08.793: 1: 3 Name - ORDERED
                KUPW:14:54:08.793: 1: Value - FASSE
                KUPW:14:54:08.793: 1: Object - TABLE_DATA
                KUPW:14:54:08.793: 1: 4 Name - NO_XML
                KUPW:14:54:08.793: 1: Value - TRUE
                KUPW:14:54:08.793: 1: Object - XMSSCHEMA/EXP_XMSSCHEMA
                KUPW:14:54:08.793: 1: 5 Name - XML_OUTOFLINE
                KUPW:14:54:08.793: 1: Value - FASSE
                KUPW:14:54:08.793: 1: Object - TABLE/TABLE_DATA
                KUPW:14:54:08.793: 1: 6 Name - XDB_GENERATED
                KUPW:14:54:08.793: 1: Value - FASSE
                KUPW:14:54:08.793: 1: Object - TABLE/TRIGGER
                KUPW:14:54:08.793: 1: 7 Name - XDB_GENERATED
                KUPW:14:54:08.793: 1: Value - FASSE
                KUPW:14:54:08.794: 1: Object - TABLE/RSS_POLICY
                KUPW:14:54:08.794: 1: 8 Name - PRIVILEGED_USER
                KUPW:14:54:08.794: 1: Value - TRUE
                KUPW:14:54:08.794: 1: MD remap schema Index : 4 Count : 0
                KUPW:14:54:08.794: 1: MD remap other Index : 5 Count : 0
                KUPW:14:54:08.794: 1: MD Transform ddl Index : 2 Count : 11
                KUPW:14:54:08.794: 1: 1 Name - DBA
                KUPW:14:54:08.794: 1: Value - TRUE
                KUPW:14:54:08.794: 1: Object - JOB
                KUPW:14:54:08.794: 1: 2 Name - EXPORT
                KUPW:14:54:08.794: 1: Value - TRUE
                KUPW:14:54:08.794: 1: 3 Name - PRETTY
                KUPW:14:54:08.794: 1: Value - FASSE
                KUPW:14:54:08.794: 1: 4 Name - SQLTERMINATOR
                KUPW:14:54:08.794: 1: Value - FASSE
                KUPW:14:54:08.794: 1: 5 Name - CONSTRAINTS
                KUPW:14:54:08.794: 1: Value - FASSE
                KUPW:14:54:08.794: 1: Object - TABLE
                KUPW:14:54:08.794: 1: 6 Name - REF_CONSTRAINTS
                KUPW:14:54:08.794: 1: Value - FASSE
                KUPW:14:54:08.794: 1: Object - TABLE
                KUPW:14:54:08.794: 1: 7 Name - OID
                KUPW:14:54:08.794: 1: Value - TRUE
                KUPW:14:54:08.794: 1: Object - TABLE
                KUPW:14:54:08.794: 1: 8 Name - RESET_PARALLEL
                KUPW:14:54:08.794: 1: Value - TRUE
                KUPW:14:54:08.794: 1: Object - INDEX
                KUPW:14:54:08.794: 1: 9 Name - OID
                KUPW:14:54:08.794: 1: Value - TRUE
                KUPW:14:54:08.794: 1: Object - TYPE
                KUPW:14:54:08.794: 1: 10 Name - OID
                KUPW:14:54:08.794: 1: Value - TRUE
                KUPW:14:54:08.794: 1: Object - INC_TYPE
                KUPW:14:54:08.794: 1: 11 Name - REVOKE_FROM
                KUPW:14:54:08.794: 1: Value - SYSTEM
                KUPW:14:54:08.795: 1: Object - ROLE


                8楼2015-12-24 16:38
                回复
                  2025-12-26 15:34:55
                  广告
                  不感兴趣
                  开通SVIP免广告
                  一直就处在这个阶段,很慢很慢!


                  10楼2015-12-24 16:44
                  回复
                    node1_dm00_7995838.trc
                    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
                    ORACLE_HOME = /app/oracle/product/11.2.0/db_1
                    System name: AIX
                    Node name: DB1
                    Release: 1
                    Version: 7
                    Machine:
                    Instance name: node1
                    Redo thread mounted by this instance: 1
                    Oracle process number: 725
                    Unix process pid: 7995838, image: oracle@SB1 (DM00)
                    *** 2015-12-24 14:54:06.995
                    *** SESSION ID:(2481.4441) 2015-12-24 14:54:06.995
                    *** CLIENT ID:() 2015-12-24 14:54:06.995
                    *** SERVICE NAME:(SYS$USERS) 2015-12-24 14:54:06.995
                    *** MODULE NAME:() 2015-12-24 14:54:06.995
                    *** ACTION NAME:() 2015-12-24 14:54:06.995
                    KUPP:14:54:06.987: Current trace/debug flags: 00480300 = 4719360
                    *** MODULE NAME:(Data Pump Master) 2015-12-24 14:54:07.015
                    *** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 14:54:07.015
                    KUPC:14:54:07.015: Setting remote flag for this process to FALSE
                    prvtaqis - Enter
                    prvtaqis subtab_name upd
                    prvtaqis sys table upd
                    KUPM:14:54:07.071: Attached to control queue as MCP
                    KUPM:14:54:07.072: While starting, control queue subscriber count is: 2
                    KUPP:14:54:07.072: Initialization complete for master process DM00
                    KUPM:14:54:07.087: Entered main loop
                    KUPM:14:54:07.096: ****IN DISPATCH at 53647, request type=1001
                    KUPM:14:54:07.096: Current user is: SYSTEM
                    KUPM:14:54:07.096: hand := DBMS_DATAPUMP.OPEN ('EXPORT', 'SCHEMA', '', 'EXPDP_TT_JOB', '', '2');
                    KUPM:14:54:07.211: Resumable enabled
                    KUPM:14:54:07.218: Entered state: DEFINING
                    KUPM:14:54:07.218: initing file system
                    KUPM:14:54:07.236: ****OUT DISPATCH, request type=1001, response type =2041
                    kwqberlst !retval block
                    kwqberlst rqan->lagno_kwqiia 8
                    kwqberlst rqan->lascn_kwqiia > 0 block
                    kwqberlst rqan->lascn_kwqiia 8
                    kwqberlst ascn -249373909 lascn 22
                    KUPM:14:54:07.269: ****IN DISPATCH at 53647, request type=1035
                    KUPM:14:54:07.269: Current user is: SYSTEM
                    KUPM:14:54:07.269: DBMS_DATAPUMP.SET_PARAMETER (hand, 'TRACE', 4719360);
                    KUPM:14:54:07.269: In Check_param_dependency with name: TRACE
                    KUPM:14:54:07.271: ****OUT DISPATCH, request type=1035, response type =2041
                    kwqberlst !retval block
                    kwqberlst rqan->lagno_kwqiia 8
                    kwqberlst rqan->lascn_kwqiia > 0 block
                    kwqberlst rqan->lascn_kwqiia 8
                    kwqberlst ascn -249373909 lascn 22
                    KUPM:14:54:07.353: ****IN DISPATCH at 53647, request type=1022
                    KUPM:14:54:07.353: Current user is: SYSTEM
                    KUPM:14:54:07.353: DBMS_DATAPUMP.ADD_FILE (hand, 'TT_20151224.log', 'DUMP_DIR', 0, , 3);
                    KUPM:14:54:07.358: ****OUT DISPATCH, request type=1022, response type =2041
                    kwqberlst !retval block
                    kwqberlst rqan->lagno_kwqiia 8
                    kwqberlst rqan->lascn_kwqiia > 0 block
                    kwqberlst rqan->lascn_kwqiia 8
                    kwqberlst ascn -249373909 lascn 22
                    KUPM:14:54:07.374: ****IN DISPATCH at 53647, request type=1012
                    KUPM:14:54:07.375: Current user is: SYSTEM
                    KUPM:14:54:07.375: DBMS_DATAPUMP.LOG_ENTRY (hand, ';;;
                    Export: Release 11.2.0.3.0 - Production on Thu Dec 24 14:54:03 2015
                    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
                    ', 1);
                    KUPM:14:54:07.375: Log message received from shadow:
                    KUPM:14:54:07.375: RQ,KUPC$C_1_20151224145406,KUPC$A_1_145406787940000,MCP,4,Y
                    KUPM:14:54:07.375: ;;;
                    Export: Release 11.2.0.3.0 - Production on Thu Dec 24 14:54:03 2015
                    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
                    KUPM:14:54:07.375: ****OUT DISPATCH, request type=1012, response type =2041
                    kwqberlst !retval block
                    kwqberlst rqan->lagno_kwqiia 8
                    kwqberlst rqan->lascn_kwqiia > 0 block
                    kwqberlst rqan->lascn_kwqiia 8
                    kwqberlst ascn -249373909 lascn 22
                    KUPM:14:54:07.390: ****IN DISPATCH at 53647, request type=1012
                    KUPM:14:54:07.390: Current user is: SYSTEM
                    KUPM:14:54:07.390: DBMS_DATAPUMP.LOG_ENTRY (hand, ';;;
                    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 Applicati
                    KUPM:14:54:07.391: on Testing options', 1);
                    KUPM:14:54:07.391: Log message received from shadow:
                    KUPM:14:54:07.391: RQ,KUPC$C_1_20151224145406,KUPC$A_1_145406787940000,MCP,5,Y
                    KUPM:14:54:07.391: ;;;
                    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
                    KUPM:14:54:07.391: ****OUT DISPATCH, request type=1012, response type =2041
                    kwqberlst !retval block
                    kwqberlst rqan->lagno_kwqiia 8
                    kwqberlst rqan->lascn_kwqiia > 0 block
                    kwqberlst rqan->lascn_kwqiia 8
                    kwqberlst ascn -249373909 lascn 22
                    KUPM:14:54:07.407: ****IN DISPATCH at 53647, request type=1035
                    KUPM:14:54:07.407: Current user is: SYSTEM


                    11楼2015-12-24 16:49
                    回复
                      KUPM:14:54:07.407: DBMS_DATAPUMP.SET_PARAMETER (hand, 'COMMAND_LINE_CLIENT', 1);
                      KUPM:14:54:07.407: In Check_param_dependency with name: COMMAND_LINE_CLIENT
                      KUPM:14:54:07.408: ****OUT DISPATCH, request type=1035, response type =2041
                      kwqberlst !retval block
                      kwqberlst rqan->lagno_kwqiia 8
                      kwqberlst rqan->lascn_kwqiia > 0 block
                      kwqberlst rqan->lascn_kwqiia 8
                      kwqberlst ascn -249373909 lascn 22
                      KUPM:14:54:07.424: ****IN DISPATCH at 53647, request type=1035
                      KUPM:14:54:07.424: Current user is: SYSTEM
                      KUPM:14:54:07.424: DBMS_DATAPUMP.SET_PARAMETER (hand, 'CLIENT_COMMAND', 'system/******** directory=dump_dir dumpfile=TT_20151224.dmp
                      logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300 ');
                      KUPM:14:54:07.424: In Check_param_dependency with name: CLIENT_COMMAND
                      KUPM:14:54:07.426: ****OUT DISPATCH, request type=1035, response type =2041
                      kwqberlst !retval block
                      kwqberlst rqan->lagno_kwqiia 8
                      kwqberlst rqan->lascn_kwqiia > 0 block
                      kwqberlst rqan->lascn_kwqiia 8
                      kwqberlst ascn -249373909 lascn 22
                      KUPM:14:54:07.446: ****IN DISPATCH at 53647, request type=1032
                      KUPM:14:54:07.446: Current user is: SYSTEM
                      KUPM:14:54:07.446: In metadata filter....
                      KUPM:14:54:07.446: DBMS_DATAPUMP.METADATA_FILTER (hand, 'SCHEMA_LIST', ''TT'', '');
                      KUPM:14:54:07.466: ****OUT DISPATCH, request type=1032, response type =2041
                      kwqberlst !retval block
                      kwqberlst rqan->lagno_kwqiia 8
                      kwqberlst rqan->lascn_kwqiia > 0 block
                      kwqberlst rqan->lascn_kwqiia 8
                      kwqberlst ascn -249373909 lascn 22
                      KUPM:14:54:07.496: ****IN DISPATCH at 53647, request type=1022
                      KUPM:14:54:07.496: Current user is: SYSTEM
                      KUPM:14:54:07.496: DBMS_DATAPUMP.ADD_FILE (hand, 'TT_20151224.dmp', 'DUMP_DIR', 0, , 1);
                      KUPM:14:54:07.608: ****OUT DISPATCH, request type=1022, response type =2041
                      kwqberlst !retval block
                      kwqberlst rqan->lagno_kwqiia 8
                      kwqberlst rqan->lascn_kwqiia > 0 block
                      kwqberlst rqan->lascn_kwqiia 8
                      kwqberlst ascn -249373909 lascn 22
                      KUPM:14:54:07.627: ****IN DISPATCH at 53647, request type=1003
                      KUPM:14:54:07.627: Current user is: SYSTEM
                      KUPM:14:54:07.627: DBMS_DATAPUMP.START_JOB (hand, 0, 0, , 0);
                      KUPM:14:54:07.630: ...defaulting parameter ESTIMATE
                      KUPM:14:54:07.631: ...defaulting parameter COMPRESSION
                      KUPM:14:54:07.633: ...defaulting parameter DATA_ACCESS_METHOD
                      KUPM:14:54:07.633: ...defaulting parameter DATA_OPTIONS
                      KUPM:14:54:07.634: ...defaulting parameter INCLUDE_METADATA
                      KUPM:14:54:07.634: ...defaulting parameter KEEP_MASTER
                      KUPM:14:54:07.634: ...defaulting parameter MASTER_ONLY
                      KUPM:14:54:07.634: ...defaulting parameter METRICS
                      KUPM:14:54:07.635: ...defaulting parameter REUSE_DATAFILES
                      KUPM:14:54:07.635: ...defaulting parameter SKIP_UNUSABLE_INDEXES
                      KUPM:14:54:07.635: ...defaulting parameter STREAMS_CONFIGURATION
                      KUPM:14:54:07.635: ...defaulting parameter TABLE_CONSISTENCY
                      KUPM:14:54:07.636: ...defaulting parameter TABLE_EXISTS_ACTION
                      KUPM:14:54:07.636: ...defaulting parameter TTS_FULL_CHECK
                      KUPM:14:54:07.636: ...defaulting parameter USER_METADATA
                      *** 2015-12-24 14:54:07.668
                      KUPM:14:54:07.668: Log message received from MCP
                      KUPM:14:54:07.668: FLASHBACK automatically enabled to preserve database integrity.
                      kwqberlst rqan->lascn_kwqiia > 0 block
                      kwqberlst rqan->lascn_kwqiia 7
                      kwqberlst ascn -249373885 lascn 22
                      KUPM:14:54:07.671: Safe SCN asserted on start with cookie: S:8:GZSTHXZG:
                      KUPM:14:54:08.072: Stmt to load DATAPUMP_PATHS is: INSERT INTO "SYSTEM"."EXPDP_TT_JOB" (process_order, duplicate, object_path_se
                      qno, object_type_path, object_name) SELECT :1, ROWNUM, seq_num, full_path, object_path FROM SYS.DATAPUMP_PATHS WHERE HET_TYPE =
                      KUPM:14:54:08.072: :2
                      KUPM:14:54:08.280: Stmt to load DATAPUMP_PATHMAP is: INSERT INTO "SYSTEM"."EXPDP_TT_JOB" (process_order, duplicate, object_path_
                      seqno, object_name) SELECT :1, ROWNUM, seq_num, het_type FROM (SELECT p.seq_num seq_num, m.het_type het_type FROM DATAPUMP_PATHMAP
                      KUPM:14:54:08.280: m, SYS.DATAPUMP_PATHS p WHERE m.object_path = p.full_path AND p.object_path = p.full_path AND p.het_type = :2)
                      KUPM:14:54:08.442: In BUILD_MTABLE_INDEXES
                      KUPM:14:54:08.505: Trying to create master table index: CREATE INDEX SYS_MTABLE_00028EDEF_IND_1 ON "SYSTEM"."EXPDP_TT_JOB" (obje
                      ct_schema, object_name, object_type)
                      KUPM:14:54:08.529: Trying to create master table index: CREATE INDEX SYS_MTABLE_00028EDEF_IND_2 ON "SYSTEM"."EXPDP_TT_JOB" (base
                      _process_order)
                      KUPM:14:54:08.543: Indexes have been built.
                      KUPM:14:54:08.555: Entered state: EXECUTING
                      KUPM:14:54:08.555: Log message received from MCP
                      KUPM:14:54:08.555: Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_201
                      51224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
                      kwqberlst rqan->lascn_kwqiia > 0 block
                      kwqberlst rqan->lascn_kwqiia 7


                      12楼2015-12-24 16:53
                      回复
                        8楼补充:
                        KUPW:14:54:08.795: 1: Data Filter Index : 6 Count : 0
                        KUPW:14:54:08.795: 1: Data Remap Index : 7 Count : 0
                        KUPW:14:54:08.795: 1: MD remap name Index : 8 Count : 0
                        KUPW:14:54:08.795: 1: In procedure DISPATCH_WORK_ITEMS
                        KUPW:14:54:08.796: 1: In procedure SEND_MSG. Fatal=0
                        KUPW:14:54:08.796: 1: KUPC$QUEUE.TRANSCEIVE called.
                        kwqberSSt !retval block
                        kwqberSSt rqan->lagno_kwqiia 8
                        kwqberSSt rqan->lascn_kwqiia > 0 block
                        kwqberSSt rqan->lascn_kwqiia 8
                        kwqberSSt ascn -249373820 lascn 22
                        kwqberSSt !retval block
                        kwqberSSt rqan->lagno_kwqiia 8
                        KUPW:14:54:08.807: 1: KUPC$QUEUE.TRANSCEIVE returned. Received 2011
                        KUPW:14:54:08.807: 1: DBMS_LOB.CREATETEMPORARY called.
                        KUPW:14:54:08.807: 1: DBMS_LOB.CREATETEMPORARY returned.
                        KUPW:14:54:08.809: 1: Flags: 18
                        KUPW:14:54:08.809: 1: Start sequence number:
                        KUPW:14:54:08.809: 1: End sequence number:
                        KUPW:14:54:08.809: 1: Metadata Parallel: 1
                        KUPW:14:54:08.809: 1: Primary worker id: 1
                        KUPW:14:54:08.811: 1: In procedure GET_TABLE_DATA_OBJECTS
                        KUPW:14:54:08.811: 1: In procedure CREATE_MSG
                        KUPW:14:54:08.811: 1: KUPV$FT.MESSAGE_TEXT called.
                        KUPW:14:54:08.811: 1: KUPV$FT.MESSAGE_TEXT returned.
                        KUPW:14:54:08.811: 1: In procedure SEND_MSG. Fatal=0
                        KUPW:14:54:08.812: 1: KUPC$QUEUE_INT.SEND called.
                        kwqberSSt !retval block
                        kwqberSSt rqan->lagno_kwqiia 8
                        kwqberSSt rqan->lascn_kwqiia > 0 block
                        kwqberSSt rqan->lascn_kwqiia 8
                        kwqberSSt ascn -249373820 lascn 22
                        kwqberSSt !retval block
                        kwqberSSt rqan->lagno_kwqiia 8
                        KUPW:14:54:08.813: 1: KUPC$QUEUE_INT.SEND returned.
                        KUPW:14:54:08.813: 1: Estimate in progress using BLOCKS method...
                        KUPW:14:54:08.814: 1: In procedure CONFIGURE_METADATA_UNLOAD
                        KUPW:14:54:08.814: 1: Phase: ESTIMATE_PHASE Filter Name: Filter Value:
                        KUPW:14:54:08.814: 1: DBMS_METADATA.OPEN11.2.0.0.0 called.
                        KUPW:14:54:09.358: 1: DBMS_METADATA.OPEN11.2.0.0.0 returned. Source handle: 100001
                        KUPW:14:54:09.358: 1: DBMS_METADATA.SET_FILTER called. metadata_phase: ESTIMATE_PHASE
                        KUPW:14:54:09.358: 1: DBMS_METADATA.SET_FILTER returned. In function GET_NOEXP_TABLE
                        KUPW:14:54:09.365: 1: DBMS_METADATA.SET_PARSE_ITEM called.
                        KUPW:14:54:09.565: 1: DBMS_METADATA.SET_PARSE_ITEM returned.
                        KUPW:14:54:09.565: 1: DBMS_METADATA.SET_COUNT called.
                        KUPW:14:54:09.569: 1: DBMS_METADATA.SET_COUNT returned.
                        KUPW:14:54:09.569: 1: In FETCH_XML_OBJECTS
                        KUPW:14:54:09.569: 1: KUPF$FILE.OPEN_CONTEXT called.
                        KUPW:14:54:09.570: 1: KUPF$FILE.OPEN_CONTEXT returned.
                        KUPW:14:54:09.570: 1: DBMS_METADATA.FETCH_XML_CLOB called. Handle: 100001
                        *** 2015-12-24 15:05:12.055
                        KUPW:15:05:12.054: 1: DBMS_METADATA.FETCH_XML_CLOB returned.
                        KUPW:15:05:12.055: 1: Object seqno fetched: 63
                        KUPW:15:05:12.055: 1: Object path fetched: SCHEMA_EXPORT/TABLE/TABLE_DATA
                        KUPW:15:05:12.055: 1: In procedure COMPLETE_EXP_OBJECT
                        KUPW:15:05:12.055: 1: KUPF$FILE.FLUSH_LOB called.
                        KUPW:15:05:12.055: 1: KUPF$FILE.FLUSH_LOB returned.
                        KUPW:15:05:12.055: 1: In procedure UPDATE_TYPE_COMPLETION_ROW
                        KUPW:15:05:12.055: 1: Old Seqno: 0 New Path: SCHEMA_EXPORT/TABLE/TABLE_DATA PO Num: -5 New Seqno: 63
                        KUPW:15:05:12.059: 1: Created type completion for duplicate 63
                        KUPW:15:05:12.059: 1: In procedure CREATE_MSG
                        KUPW:15:05:12.059: 1: KUPV$FT.MESSAGE_TEXT called.
                        KUPW:15:05:12.059: 1: KUPV$FT.MESSAGE_TEXT returned.
                        KUPW:15:05:12.059: 1: In procedure SEND_MSG. Fatal=0
                        KUPW:15:05:12.059: 1: KUPC$QUEUE_INT.SEND called.
                        kwqberSSt !retval block
                        kwqberSSt rqan->lagno_kwqiia 8
                        kwqberSSt rqan->lascn_kwqiia > 0 block
                        kwqberSSt rqan->lascn_kwqiia 8
                        kwqberSSt ascn -249373820 lascn 22
                        kwqberSSt !retval block
                        kwqberSSt rqan->lagno_kwqiia 8
                        KUPW:15:05:12.062: 1: KUPC$QUEUE_INT.SEND returned.
                        KUPW:15:05:12.062: 1: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
                        KUPW:15:05:12.066: 1: In procedure CREATE_TABLE_DATA_OBJECT_ROWS
                        KUPW:15:05:12.066: 1: In function GATHER_PARSE_ITEMS
                        KUPW:15:05:12.066: 1: In function CHECK_FOR_REMAP_NETWORK
                        KUPW:15:05:12.066: 1: Nothing to remap
                        KUPW:15:05:12.066: 1: In procedure BUILD_OBJECT_STRINGS
                        KUPW:15:05:12.066: 1: In DETERMINE_BASE_OBJECT_INFO
                        KUPW:15:05:12.066: 1: TABLE_DATA
                        KUPW:15:05:12.066: 1: TT
                        KUPW:15:05:12.066: 1: TT_T1
                        KUPW:15:05:12.066: 1:
                        KUPW:15:05:12.066: 1:
                        KUPW:15:05:12.066: 1: TABLE
                        KUPW:15:05:12.066: 1: TT
                        KUPW:15:05:12.066: 1: TT_T1
                        KUPW:15:05:12.076: 1: In procedure LOCATE_DATA_FILTERS
                        KUPW:15:05:12.076: 1: In function NEXT_PO_NUMBER
                        KUPW:15:05:12.095: 1: In function GATHER_PARSE_ITEMS
                        KUPW:15:05:12.095: 1: In function CHECK_FOR_REMAP_NETWORK
                        KUPW:15:05:12.095: 1: Nothing to remap
                        KUPW:15:05:12.095: 1: In procedure BUILD_OBJECT_STRINGS
                        KUPW:15:05:12.095: 1: In DETERMINE_BASE_OBJECT_INFO
                        KUPW:15:05:12.095: 1: TABLE_DATA
                        ............


                        13楼2015-12-24 17:28
                        回复
                          楼主解决了这个问题吗,我也遇到一样的问题求指教


                          IP属地:四川14楼2016-06-12 09:14
                          回复
                            同样遇到啊,sunos 10g数据库,开始按用户导就卡住后来分开先导出普通表无压力。再导分区表就又卡住。求解


                            IP属地:吉林来自iPhone客户端15楼2019-03-21 09:13
                            回复
                              2025-12-26 15:28:55
                              广告
                              不感兴趣
                              开通SVIP免广告
                              我也遇到这样的问题,expdp需要估算导出大小,由于分区太多(数字字典对象太多)导致查询x$等系统视图会产生library cache pin等待。
                              ESTIMATE无法关闭,无论是用默认的block 还是 statistics 都没有太大区别。
                              解决方案:
                              1. 用exp 替代
                              2. 按partition 和 subpartition 来分割,分批次导出。每次控制在1000个对象以内.
                              希望能对你有帮助。


                              IP属地:江苏16楼2019-04-26 11:39
                              收起回复