oracle impdp compilation,关于impdp的问题

论坛 期权论坛 脚本     
已经匿名di用户   2022-4-26 16:01   3536   0

;;;

Import: Release 11.2.0.3.0 - Production on Thu Jan 23 17:54:53 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, OLAP, Data Mining and Real Application Testing options

Starting "SYSTEM"."SMIS": system/******** directory=dump network_link=source_dm_link schemas=smis logfile=smis.log parallel=4 job_name=smis cluster=n table_exists_action=append

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 57.95 GB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/DB_LINK

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

. . imported "SMIS"."S_GL_BASE_2USD_AMT_ACC_D" 92310 rows

. . imported "SMIS"."S_GL_BASE_2RMB_AMT_ACC_D" 196548 rows

. . imported "SMIS"."LFL" 875589 rows

. . imported "SMIS"."S_GL_DERIVE_DEFINE" 1224 rows

. . imported "SMIS"."CURRENCY_CODE" 9 rows

. . imported "SMIS"."INPUT_1242287238905" 3 rows

. . imported "SMIS"."S_CM_ACCCODETRANS" 3726 rows

. . imported "SMIS"."S_CM_ACCCODE_PROD_LOB" 6341 rows

. . imported "SMIS"."S_GL_ACCCODE" 7050 rows

. . imported "SMIS"."S_GL_ATTRIBUTE_TYPE" 8 rows

. . imported "SMIS"."S_GL_ATTRIBUTE_VALUE" 331 rows

. . imported "SMIS"."S_GL_CODE4" 4032 rows

. . imported "SMIS"."S_GL_CURRENCYCODE" 203 rows

. . imported "SMIS"."S_GL_CURRENCYCODE1" 203 rows

. . imported "SMIS"."S_GL_DATES" 5142 rows

. . imported "SMIS"."S_GL_DEPARTCODE1" 4032 rows

. . imported "SMIS"."S_GL_DEPARTCODE2" 4032 rows

. . imported "SMIS"."S_GL_DEPARTCODE_T" 4032 rows

. . imported "SMIS"."S_GL_ENGINE_DATE_LOG" 1433 rows

. . imported "SMIS"."S_GL_MEASURES" 22 rows

. . imported "SMIS"."S_GL_BASE_STDC_AMT_ACC_D" 1742785 rows

. . imported "SMIS"."S_GL_DEPARTCODE" 2283209 rows

. . imported "SMIS"."S_GL_DERIVE_AMT_ACC_D" 4292888 rows

. . imported "SMIS"."FR_DATA_2007" 0 rows

. . imported "SMIS"."FR_DATA_2008" 0 rows

. . imported "SMIS"."GL_CURR_CNTRA" 0 rows

. . imported "SMIS"."GS_DATA_2007" 0 rows

. . imported "SMIS"."GS_DATA_2008" 0 rows

. . imported "SMIS"."INPUT_1242287738292" 0 rows

. . imported "SMIS"."INPUT_1242352841480" 0 rows

. . imported "SMIS"."PB_DATA_2006" 0 rows

. . imported "SMIS"."PB_DATA_2007" 0 rows

. . imported "SMIS"."PB_DATA_2008" 0 rows

. . imported "SMIS"."PROC_STATE" 0 rows

. . imported "SMIS"."RP_COLUMN" 0 rows

. . imported "SMIS"."RP_PB_DATE" 0 rows

. . imported "SMIS"."RP_ROW" 0 rows

. . imported "SMIS"."RP_TABLE" 0 rows

. . imported "SMIS"."S_CM_PROCEDURE_SQL" 0 rows

. . imported "SMIS"."S_CRD_BASE_DATA" 0 rows

. . imported "SMIS"."S_CRD_MEASURE" 0 rows

. . imported "SMIS"."S_GL_ACCCODE_HIS" 0 rows

. . imported "SMIS"."S_GL_BASE_AMT_ADM_CHECK" 0 rows

. . imported "SMIS"."S_GL_DAILYRATES" 0 rows

. . imported "SMIS"."S_GL_DEPART_COMPARE" 0 rows

. . imported "SMIS"."S_GL_DERIVE_AMT_ACC_D_BACK" 0 rows

. . imported "SMIS"."S_GL_PERIODS" 0 rows

. . imported "SMIS"."S_GL_code3" 0 rows

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

ORA-39082: Object type ALTER_PROCEDURE:"SMIS"."SP_B_M_CIEP_GLXXZXDATA" created with compilation warnings

ORA-39082: Object type ALTER_PROCEDURE:"SMIS"."SP_B_M_PUB_CUST_DEZJ" created with compilation warnings

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "SYSTEM"."SMIS" completed with 2 error(s) at 18:46:15

分享到 :
0 人收藏
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

积分:81
帖子:4969
精华:0
期权论坛 期权论坛
发布
内容

下载期权论坛手机APP