数据泵批量导出导入非系统用户数据

原创 Leo 2023-02-19

1287

文档课题：数据泵批量导出导入非系统用户数据 parfile.
1、导出
1.1、字符集
SYS@orcl> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
1.2、建目录
[oracle@leo-11g-ogg ~]$ mkdir -p /home/oracle/dpbak/data/
[oracle@leo-11g-ogg ~]$ mkdir -p /home/oracle/dpbak/logs/
[oracle@leo-11g-ogg ~]$ mkdir scripts
SYS@orcl> create directory pump_dir as '/home/oracle/dpbak/data/';

Directory created.

SYS@orcl> create directory pump_log as '/home/oracle/dpbak/logs/';

Directory created.
1.3、编写parfile
[oracle@leo-11g-ogg scripts]$ pwd
/home/oracle/scripts
[oracle@leo-11g-ogg scripts]$ vi expdpfull.par
添加如下：
job_name=jszx_expdp_full_new2
parallel=16
full=y
filesize=20m
dumpfile=pump_dir:mydb_%U.dat
logfile=pump_log:expdp_11g_log.txt
cluster=N
COMPRESSION=ALL
REUSE_DUMPFILES=Y
exclude=statistics
exclude=schema:"in ('SYSTEM','SYSMAN','WMSYS','OUTLN','DIP','ORACLE_OCM','APPQOSSYS','EXFSYS','XDB','ORDSYS','CTXSYS','ORDDATA','ORDPLUGINS','SI_INFORMTN_SCHEMA','MDSYS','OLAPSYS','MDDATA','SPATIAL_WFS_ADMIN_USR','SPATIAL_CSW_ADMIN_USR','FLOWS_FILES','APEX_PUBLIC_USER','APEX_030200','OWBSYS','OWBSYS_AUDIT','ANONYMOUS','XS$NULL')"
注意：此处未排除ogg用户，导出日志未见ogg数据是因为ogg用户下没有数据,但ogg用户的相关定义会被导出，在导入时要特别注意.
[oracle@leo-11g-ogg scripts]$ vi expdpfull.sh
添加如下：
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
cd /home/oracle/dpbak/data/
rm /home/oracle/dpbak/data/*
expdp \'/ as sysdba \' parfile=/home/oracle/scripts/expdpfull.par
1.4、导出作业
--执行expdp导出作业.
[oracle@leo-11g-ogg scripts]$ nohup ./expdpfull.sh &
[oracle@leo-11g-ogg scripts]$ tail -5000f nohup.out

Export: Release 11.2.0.4.0 - Production on Thu Dec 22 14:20:45 2022

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."JSZX_EXPDP_FULL_NEW2": "/******** AS SYSDBA" parfile=/home/oracle/scripts/expdpfull.par
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 21.25 MB
. . exported "SCOTT"."DEPT"                              5.093 KB       5 rows
. . exported "SCOTT"."EMP"                               5.625 KB      14 rows
. . exported "SCOTT"."SALGRADE"                          4.882 KB       5 rows
. . exported "SCOTT"."TESTDDL"                           5.382 KB    1000 rows
. . exported "SCOTT"."BONUS"                                 0 KB       0 rows
. . exported "LEO"."TEST"                                2.062 MB 182306 rows
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT
Master table "SYS"."JSZX_EXPDP_FULL_NEW2" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.JSZX_EXPDP_FULL_NEW2 is:
/home/oracle/dpbak/data/mydb_01.dat
/home/oracle/dpbak/data/mydb_02.dat
/home/oracle/dpbak/data/mydb_03.dat
/home/oracle/dpbak/data/mydb_04.dat
Job "SYS"."JSZX_EXPDP_FULL_NEW2" successfully completed at Thu Dec 22 14:21:26 2022 elapsed 0 00:00:40
2、导入
2.1、目标端字符集
SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
2.2、dmp文件处理
sftp> lcd C:\Users\Administrator\Desktop\impdp
sftp> cd /home/oracle/dpbak/data
sftp> get *
2.3、执行导入
C:\Users\Administrator>impdp system/oracle_4U@192.168.11.1:1521/orcl directory=impdp_dir dumpfile=mydb_01.dat,mydb_02.dat,mydb_03.dat,mydb_04.dat full=y logfile=impdp.log

特别说明：通过上述导出的dmp文件在导入时注意以下,否则会像如下所示告警.
a、导入前设置数据库字符集环境变量.
b、源端导出的用户在目标端要有对应的用户，并且有对应的表空间.

Import: Release 19.0.0.0.0 - Production on 星期四 12月 22 14:59:40 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

连接到: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
已成功加载/卸载了主表 "SYSTEM"."SYS_IMPORT_FULL_01"
已在 AL32UTF8 字符集和 AL16UTF16 NCHAR 字符集中完成导入
已在 AL32UTF8 字符集和 UTF8 NCHAR 字符集中完成导出
警告: 字符集转换过程中可能出现数据丢失情况
启动 "SYSTEM"."SYS_IMPORT_FULL_01": system/********@192.168.11.1:1521/orcl directory=impdp_dir dumpfile=mydb_01.dat,mydb_02.dat,mydb_03.dat,mydb_04.dat full=y logfile=impdp.log
处理对象类型 DATABASE_EXPORT/TABLESPACE
ORA-31684: 对象类型 TABLESPACE:"UNDOTBS1" 已存在

ORA-31684: 对象类型 TABLESPACE:"TEMP" 已存在

ORA-31684: 对象类型 TABLESPACE:"USERS" 已存在

ORA-39083: 对象类型 TABLESPACE:"LEO_TS" 创建失败, 出现错误:
ORA-01119: 创建数据库文件 '/u01/app/oracle/oradata/orcl/leo_ts01.dbf' 时出错
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: ？???？？?
O/S-Error: (OS 3) ？？？????？???？?????

失败的 sql 为:
CREATE TABLESPACE "LEO_TS" DATAFILE '/u01/app/oracle/oradata/orcl/leo_ts01.dbf' SIZE 104857600 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO

处理对象类型 DATABASE_EXPORT/PROFILE
处理对象类型 DATABASE_EXPORT/SYS_USER/USER
ORA-31685: 由于权限不足, 对象类型 USER:"SYS" 失败.失败的 sql 为:
ALTER USER "SYS" IDENTIFIED BY VALUES 'S:2EBACCE54EE63069670B582E5EDC5C6A500897138AC895D11DD23BF42611;A586E74A0FA6A0BC' TEMPORARY TABLESPACE "TEMP"

处理对象类型 DATABASE_EXPORT/SCHEMA/USER
ORA-31684: 对象类型 USER:"MGMT_VIEW" 已存在

ORA-39083: 对象类型 USER:"OGG" 创建失败, 出现错误:
ORA-00959: 表空间 'OGG_TBS' 不存在

失败的 sql 为:
CREATE USER "OGG" IDENTIFIED BY VALUES 'S:86AD55F8D7B481B89A327EC59BF8F1F0DBD2158A776AB3DA93A89FA8F43C;9D40CEB03B40836B' DEFAULT TABLESPACE "OGG_TBS" TEMPORARY TABLESPACE "TEMP"

ORA-39083: 对象类型 USER:"LEO" 创建失败, 出现错误:
ORA-00959: 表空间 'LEO_TS' 不存在

失败的 sql 为:
CREATE USER "LEO" IDENTIFIED BY VALUES 'S:C5E059443A8718B6A0D350F9239C490C3336ED960D920BEF6CE3C1E3E27A;17343090FE6942BE' DEFAULT TABLESPACE "LEO_TS" TEMPORARY TABLESPACE "TEMP"

处理对象类型 DATABASE_EXPORT/ROLE
ORA-31684: 对象类型 ROLE:"SELECT_CATALOG_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"EXECUTE_CATALOG_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"DBFS_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"AQ_ADMINISTRATOR_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"AQ_USER_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"ADM_PARALLEL_EXECUTE_TASK" 已存在

ORA-31684: 对象类型 ROLE:"GATHER_SYSTEM_STATISTICS" 已存在

ORA-31684: 对象类型 ROLE:"RECOVERY_CATALOG_OWNER" 已存在

ORA-31684: 对象类型 ROLE:"SCHEDULER_ADMIN" 已存在

ORA-31684: 对象类型 ROLE:"HS_ADMIN_SELECT_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"HS_ADMIN_EXECUTE_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"HS_ADMIN_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"GLOBAL_AQ_USER_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"OEM_ADVISOR" 已存在

ORA-31684: 对象类型 ROLE:"OEM_MONITOR" 已存在

ORA-31684: 对象类型 ROLE:"WM_ADMIN_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"JAVAUSERPRIV" 已存在

ORA-31684: 对象类型 ROLE:"JAVAIDPRIV" 已存在

ORA-31684: 对象类型 ROLE:"JAVASYSPRIV" 已存在

ORA-31684: 对象类型 ROLE:"JAVADEBUGPRIV" 已存在

ORA-31684: 对象类型 ROLE:"EJBCLIENT" 已存在

ORA-31684: 对象类型 ROLE:"JMXSERVER" 已存在

ORA-31684: 对象类型 ROLE:"JAVA_ADMIN" 已存在

ORA-31684: 对象类型 ROLE:"JAVA_DEPLOY" 已存在

ORA-31684: 对象类型 ROLE:"CTXAPP" 已存在

ORA-31684: 对象类型 ROLE:"XDBADMIN" 已存在

ORA-31684: 对象类型 ROLE:"XDB_SET_INVOKER" 已存在

ORA-31684: 对象类型 ROLE:"AUTHENTICATEDUSER" 已存在

ORA-31684: 对象类型 ROLE:"XDB_WEBSERVICES" 已存在

ORA-31684: 对象类型 ROLE:"XDB_WEBSERVICES_WITH_PUBLIC" 已存在

ORA-31684: 对象类型 ROLE:"XDB_WEBSERVICES_OVER_HTTP" 已存在

ORA-31684: 对象类型 ROLE:"ORDADMIN" 已存在

ORA-31684: 对象类型 ROLE:"CWM_USER" 已存在

ORA-31684: 对象类型 ROLE:"SPATIAL_WFS_ADMIN" 已存在

ORA-31684: 对象类型 ROLE:"WFS_USR_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"SPATIAL_CSW_ADMIN" 已存在

ORA-31684: 对象类型 ROLE:"CSW_USR_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"MGMT_USER" 已存在

ORA-31684: 对象类型 ROLE:"APEX_ADMINISTRATOR_ROLE" 已存在

ORA-31684: 对象类型 ROLE:"OWB$CLIENT" 已存在

ORA-31684: 对象类型 ROLE:"OWB_DESIGNCENTER_VIEW" 已存在

ORA-31684: 对象类型 ROLE:"OWB_USER" 已存在

处理对象类型 DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','"OGG"',TRUE);COMMIT; END;

ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"ALINA"',TRUE);
COMMIT; END;

ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE, '"ALINA"',TRUE);
COMMIT; END;

ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE_SET, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE_SET, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE_SET, '"ALINA"',TRUE);
COMMIT; END;

ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','"OGG"',TRUE);COMMIT; END;

ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"ALINA"',TRUE);
COMMIT; END;

ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE, '"ALINA"',TRUE);
COMMIT; END;

ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE_SET, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE_SET, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE_SET, '"ALINA"',TRUE);
COMMIT; END;

ORA-39126: 在 KUPW$WORKER.SEND_TRACE_MSG [KUPW: ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE_SET, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE_SET, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE_SET, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE_SET, '"ALINA"',TRUE);
COMMIT; END;
] 中 Worker 发生意外致命错误
PROC_SYSTEM_GRANT
ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 12620
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 34278

----- PL/SQL Call Stack -----
object      line object
handle    number name
00007FF97F7656C0     33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FF97F7656C0     12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FF97F7656C0     34341 package body SYS.KUPW$WORKER.SEND_TRACE_MSG
00007FF97F7656C0     28767 package body SYS.KUPW$WORKER.SEND_MSG
00007FF97F7656C0      5418 package body SYS.KUPW$WORKER.LOAD_METADATA
00007FF97F7656C0     13781 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FF97F7656C0      2429 package body SYS.KUPW$WORKER.MAIN
00007FF97F76B538         2 anonymous block

KUPW: In procedure UPDATE_TYPE_COMPLETION_ROW
KUPW: Old Seqno: 38 New Path: PO Num: -6 New Seqno: 0 error count: 1
KUPW: Primary row is: FALSE
KUPW: Working on old seqno with count of: 5
KUPW: In procedure SEND_MSG. Fatal=0
KUPW: Error count: 4
KUPW: ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','"OGG"',TRUE);COMMIT; END;

KUPW: ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, '"ALINA"',TRUE);
COMMIT; END;

KUPW: ORA-39083: 对象类型 PROC_SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"AQ_ADMINISTRATOR_ROLE"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_OBJ, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_RULE, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_RULE, '"ALINA"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE, '"OGG"',TRUE);

SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_RULE, '"ALINA"',TRUE);
COMMIT; END;

KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小

处理对象类型 DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT SELECT ANY TRANSACTION TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT FLASHBACK ANY TABLE TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT SELECT ANY DICTIONARY TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT DROP ANY DIRECTORY TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT CREATE ANY DIRECTORY TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT CREATE SEQUENCE TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT SELECT ANY TABLE TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT ALTER ANY TABLE TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT CREATE TABLE TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT BECOME USER TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT UNLIMITED TABLESPACE TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT RESTRICTED SESSION TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT ALTER SESSION TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT CREATE SESSION TO "OGG"

ORA-39083: 对象类型 SYSTEM_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'LEO' 不存在

失败的 sql 为:
GRANT UNLIMITED TABLESPACE TO "LEO"

处理对象类型 DATABASE_EXPORT/SCHEMA/ROLE_GRANT
ORA-39083: 对象类型 ROLE_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT "CONNECT" TO "OGG"

ORA-39083: 对象类型 ROLE_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT "RESOURCE" TO "OGG"

ORA-39083: 对象类型 ROLE_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT "SELECT_CATALOG_ROLE" TO "OGG"

ORA-39083: 对象类型 ROLE_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT "DBA" TO "OGG"

ORA-39083: 对象类型 ROLE_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT "GGS_GGSUSER_ROLE" TO "OGG"

ORA-39083: 对象类型 ROLE_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'LEO' 不存在

失败的 sql 为:
GRANT "CONNECT" TO "LEO"

ORA-39083: 对象类型 ROLE_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'LEO' 不存在

失败的 sql 为:
GRANT "RESOURCE" TO "LEO"

处理对象类型 DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
ORA-39083: 对象类型 DEFAULT_ROLE:"OGG" 创建失败, 出现错误:
ORA-01918: 用户 'OGG' 不存在

失败的 sql 为:
ALTER USER "OGG" DEFAULT ROLE ALL

ORA-39083: 对象类型 DEFAULT_ROLE:"LEO" 创建失败, 出现错误:
ORA-01918: 用户 'LEO' 不存在

失败的 sql 为:
ALTER USER "LEO" DEFAULT ROLE ALL

处理对象类型 DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
ORA-39083: 对象类型 TABLESPACE_QUOTA:"LEO" 创建失败, 出现错误:
ORA-01918: 用户 'LEO' 不存在

失败的 sql 为:
DECLARE   TEMP_COUNT NUMBER;   SQLSTR VARCHAR2(200); BEGIN   SQLSTR := 'ALTER USER "LEO" QUOTA UNLIMITED ON "LEO_TS"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION   WHEN OTHERS THEN    IF SQLCODE = -30041 THEN       SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES               WHERE TABLESPACE_NAME = ''LEO_TS'' AND CONTENTS = ''TEMPORARY''';      EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT;      IF TEMP_COUNT = 1 THEN RETURN;       ELSE RAISE;       END IF;    ELSE      RAISE;    END IF;END;

处理对象类型 DATABASE_EXPORT/RESOURCE_COST
处理对象类型 DATABASE_EXPORT/TRUSTED_DB_LINK
处理对象类型 DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
ORA-39083: 对象类型 SEQUENCE:"OGG"."GGS_MARKER_SEQ" 创建失败, 出现错误:
ORA-01917: 用户或角色 '' 不存在

失败的 sql 为:
CREATE SEQUENCE "OGG"."GGS_MARKER_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 4501 CACHE 500 NOORDER CYCLE NOKEEP NOSCALE GLOBAL

ORA-39083: 对象类型 SEQUENCE:"OGG"."GGS_DDL_SEQ" 创建失败, 出现错误:
ORA-01917: 用户或角色 '' 不存在

失败的 sql 为:
CREATE SEQUENCE "OGG"."GGS_DDL_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 4001 CACHE 500 NOORDER CYCLE NOKEEP NOSCALE GLOBAL

处理对象类型 DATABASE_EXPORT/DIRECTORY/DIRECTORY
ORA-31684: 对象类型 DIRECTORY:"DATA_PUMP_DIR" 已存在

ORA-31684: 对象类型 DIRECTORY:"XMLDIR" 已存在

处理对象类型 DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39083: 对象类型 OBJECT_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT WRITE ON DIRECTORY "GGS_DDL_TRACE" TO "OGG" WITH GRANT OPTION

ORA-39083: 对象类型 OBJECT_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT READ ON DIRECTORY "GGS_DDL_TRACE" TO "OGG" WITH GRANT OPTION

ORA-39083: 对象类型 OBJECT_GRANT 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
GRANT EXECUTE ON DIRECTORY "GGS_DDL_TRACE" TO "OGG" WITH GRANT OPTION

处理对象类型 DATABASE_EXPORT/CONTEXT
ORA-31684: 对象类型 CONTEXT:"GLOBAL_AQCLNTDB_CTX" 已存在

ORA-31684: 对象类型 CONTEXT:"DBFS_CONTEXT" 已存在

ORA-31684: 对象类型 CONTEXT:"REGISTRY$CTX" 已存在

ORA-31684: 对象类型 CONTEXT:"LT_CTX" 已存在

ORA-31684: 对象类型 CONTEXT:"DR$APPCTX" 已存在

ORA-31684: 对象类型 CONTEXT:"EM_USER_CONTEXT" 已存在

ORA-31684: 对象类型 CONTEXT:"STORAGE_CONTEXT" 已存在

处理对象类型 DATABASE_EXPORT/SCHEMA/SYNONYM
ORA-31684: 对象类型 SYNONYM:"APEX_030200"."OWA_UTIL" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."OWA_COOKIE" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."HTP" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."HTF" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."UTL_ENCODE" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."UTL_FILE" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."UTL_HTTP" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."UTL_RAW" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."UTL_SMTP" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."UTL_URL" 已存在

ORA-31684: 对象类型 SYNONYM:"APEX_030200"."DBA_ARGUMENTS" 已存在

处理对象类型 DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: 对象类型 PROCACT_SYSTEM 创建失败, 出现错误:
ORA-20000: Incompatible version of Workspace Manager Installed

失败的 sql 为:
BEGIN
declare ver varchar2(100) ; cnt integer ; dummy integer; vdummy varchar2(30) ; compile_exception EXCEPTION; PRAGMA EXCEPTION_INIT(compile_exception, -06550); invalid_table EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_table, -00942); procedure createErrorProc is begin execute immediate 'create or replace function system.wm$_check_install return boolean is begin return true ; end;' ; end ; begin select status into vdummy from dba_registry where comp_id = 'OWM' ; if (vdummy not in ('VALID', 'UPGRADED', 'LOADED')) then raise compile_exception ; end if ; select 1 into dummy from dual where exists (select 1 from all_users where username = 'WMSYS') ; execute immediate 'create or replace function wmsys.wm$_old_version return varchar2 is begin return ''11.2.0.4.0'' ; end;' ; select count(*) into cnt from dba_procedures where object_name='LT_EXPORT_PKG' and procedure_name='IMPORTEXPORTSUPPORT'; if (cnt=0) then raise_application_error(-20000, 'Incompatible version of Workspace Manager Installed'); end if ; execute immediate 'select value from wmsys.wm$env_vars where name=''OWM_VERSION''' into ver ; if (0>0 and ver != '11.2.0.4.0') then raise_application_error(-20000, 'Unable to import due to one or more versioned tables not having a ''VERSIONED'' status'); end if ; execute immediate 'declare cnt integer ; begin select count(*) into cnt from (select workspace from wmsys.wm$version_hierarchy_table where version!=0 union all select table_name from wmsys.wm$versioned_tables) ; if (cnt>0)

ORA-39083: 对象类型 PROCACT_SYSTEM 创建失败, 出现错误:
ORA-20000: Incompatible version of Workspace Manager Installed

失败的 sql 为:
BEGIN
declare ver varchar2(100) ; cnt integer ; dummy integer; vdummy varchar2(30) ; compile_exception EXCEPTION; PRAGMA EXCEPTION_INIT(compile_exception, -06550); invalid_table EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_table, -00942); procedure createErrorProc is begin execute immediate 'create or replace function system.wm$_check_install return boolean is begin return true ; end;' ; end ; begin select status into vdummy from dba_registry where comp_id = 'OWM' ; if (vdummy not in ('VALID', 'UPGRADED', 'LOADED')) then raise compile_exception ; end if ; select 1 into dummy from dual where exists (select 1 from all_users where username = 'WMSYS') ; execute immediate 'create or replace function wmsys.wm$_old_version return varchar2 is begin return ''11.2.0.4.0'' ; end;' ; select count(*) into cnt from dba_procedures where object_name='LT_EXPORT_PKG' and procedure_name='IMPORTEXPORTSUPPORT'; if (cnt=0) then raise_application_error(-20000, 'Incompatible version of Workspace Manager Installed'); end if ; execute immediate 'select value from wmsys.wm$env_vars where name=''OWM_VERSION''' into ver ; if (0>0 and ver != '11.2.0.4.0') then raise_application_error(-20000, 'Unable to import due to one or more versioned tables not having a ''VERSIONED'' status'); end if ; execute immediate 'declare cnt integer ; begin select count(*) into cnt from (select workspace from wmsys.wm$version_hierarchy_table where version!=0 union all select table_name from wmsys.wm$versioned_tables) ; if (cnt>0)

ORA-39126: 在 KUPW$WORKER.SEND_TRACE_MSG [KUPW: ORA-39083: 对象类型 PROCACT_SYSTEM 创建失败, 出现错误:
ORA-20000: Incompatible version of Workspace Manager Installed

失败的 sql 为:
BEGIN
declare ver varchar2(100) ; cnt integer ; dummy integer; vdummy varchar2(30) ; compile_exception EXCEPTION; PRAGMA EXCEPTION_INIT(compile_exception, -06550); invalid_table EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_table, -00942); procedure createErrorProc is begin execute immediate 'create or replace function system.wm$_check_install return boolean is begin return true ; end;' ; end ; begin select status into vdummy from dba_registry where comp_id = 'OWM' ; if (vdummy not in ('VALID', 'UPGRADED', 'LOADED')) then raise compile_exception ; end if ; select 1 into dummy from dual where exists (select 1 from all_users where username = 'WMSYS') ; execute immediate 'create or replace function wmsys.wm$_old_version return varchar2 is begin return ''11.2.0.4.0'' ; end;' ; select count(*) into cnt from dba_procedures where object_name='LT_EXPORT_PKG' and procedure_name='IMPORTEXPORTSUPPORT'; if (cnt=0) then raise_application_error(-20000, 'Incompatible version of Workspace Manager Installed'); end if ; execute immediate 'select value from wmsys.wm$env_vars where name=''OWM_VERSION''' into ver ; if (0>0 and ver != '11.2.0.4.0') then raise_application_error(-20000, 'Unable to import due to one or more versioned tables not having a ''VERSIONED'' status'); end if ; execute immediate 'declare cnt integer ; begin select count(*) into cnt from (select workspace from wmsys.wm$version_hierarchy_table where version!=0 union all select table_name from wmsys.wm$versioned_tables) ; if (cnt>0)
] 中 Worker 发生意外致命错误
PROCACT_SYSTEM
ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 12620
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 34278

----- PL/SQL Call Stack -----
object      line object
handle    number name
00007FF97F7656C0     33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FF97F7656C0     12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FF97F7656C0     34341 package body SYS.KUPW$WORKER.SEND_TRACE_MSG
00007FF97F7656C0     28767 package body SYS.KUPW$WORKER.SEND_MSG
00007FF97F7656C0      5418 package body SYS.KUPW$WORKER.LOAD_METADATA
00007FF97F7656C0     13781 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FF97F7656C0      2429 package body SYS.KUPW$WORKER.MAIN
00007FF97F76B538         2 anonymous block

DBMS_LOB.TRIM
DBMS_LOB.FREETEMPORARY
DBMS_LOB.FREETEMPORARY
KUPW: In procedure UPDATE_TYPE_COMPLETION_ROW
KUPW: Old Seqno: 108 New Path: PO Num: -6 New Seqno: 0 error count: 1
KUPW: Primary row is: FALSE
KUPW: Working on old seqno with count of: 4
KUPW: In procedure SEND_MSG. Fatal=0
KUPW: Error count: 1
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小

处理对象类型 DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
处理对象类型 DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: 对象类型 PROCACT_SYSTEM 创建失败, 出现错误:
ORA-29371: 暂挂区未激活

失败的 sql 为:
BEGIN
dbms_resource_manager.set_consumer_group_mapping_pri(1,7,6,9,8,10,5,4,3,2,11);
dbms_resource_manager.set_consumer_group_mapping('ORACLE_USER','"SYSTEM"','SYS_GROUP');
dbms_resource_manager.set_consumer_group_mapping('ORACLE_USER','"SYS"','SYS_GROUP');
dbms_resource_manager.set_consumer_group_mapping('ORACLE_FUNCTION','"BACKUP"','BATCH_GROUP');
dbms_resource_manager.set_consumer_group_mapping('ORACLE_FUNCTION','"COPY"','BATCH_GROUP');
dbms_resource_manager.set_consumer_group_mapping('ORACLE_FUNCTION','"DATALOAD"','ETL_GROUP');
dbms_resource_manager.submit_pending_area;COMMIT; END;

ORA-39083: 对象类型 PROCACT_SYSTEM 创建失败, 出现错误:
ORA-01917: 用户或角色 'OGG' 不存在

失败的 sql 为:
BEGIN
SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON DBMS_AQADM TO "OGG"');COMMIT; END;

处理对象类型 DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
ORA-39083: 对象类型 PROCACT_SCHEMA 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'2991859');COMMIT; END;

ORA-39083: 对象类型 PROCACT_SCHEMA 创建失败, 出现错误:
ORA-31625: 必须有方案 LEO 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'2991859');COMMIT; END;

处理对象类型 DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
处理对象类型 DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39083: 对象类型 TABLE:"LEO"."TEST" 创建失败, 出现错误:
ORA-00959: 表空间 'LEO_TS' 不存在

失败的 sql 为:
CREATE TABLE "LEO"."TEST" ("OWNER" VARCHAR2(30 BYTE), "OBJECT_NAME" VARCHAR2(128 BYTE), "SUBOBJECT_NAME" VARCHAR2(30 BYTE), "OBJECT_ID" NUMBER, "DATA_OBJECT_ID" NUMBER, "OBJECT_TYPE" VARCHAR2(19 BYTE), "CREATED" DATE, "LAST_DDL_TIME" DATE, "TIMESTAMP" VARCHAR2(19 BYTE), "STATUS" VARCHAR2(7 BYTE), "TEMPORARY" VARCHAR2(1 BYTE), "GENERATED" VARCHAR2(1 BYTE), "SECONDARY" VARCHAR2(1 BYTE), "NAMESPACE" NUMBER, "EDITION_NAME" VARCHAR2(30 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "LEO_TS"

ORA-39083: 对象类型 TABLE:"OGG"."GGS_STICK" 创建失败, 出现错误:
ORA-01918: 用户 'OGG' 不存在

失败的 sql 为:
CREATE GLOBAL TEMPORARY TABLE "OGG"."GGS_STICK" ("PROPERTY" VARCHAR2(400 BYTE) NOT NULL ENABLE, "VALUE" VARCHAR2(400 BYTE)) ON COMMIT PRESERVE ROWS

ORA-39083: 对象类型 TABLE:"OGG"."GGS_TEMP_UK" 创建失败, 出现错误:
ORA-01918: 用户 'OGG' 不存在

失败的 sql 为:
CREATE GLOBAL TEMPORARY TABLE "OGG"."GGS_TEMP_UK" ("SEQNO" NUMBER NOT NULL ENABLE, "KEYNAME" VARCHAR2(400 BYTE), "COLNAME" VARCHAR2(400 BYTE), "NULLABLE" NUMBER, "VIRTUAL" NUMBER, "UDT" NUMBER, "ISSYS" NUMBER) ON COMMIT PRESERVE ROWS

ORA-39083: 对象类型 TABLE:"OGG"."GGS_TEMP_COLS" 创建失败, 出现错误:
ORA-01918: 用户 'OGG' 不存在

失败的 sql 为:
CREATE GLOBAL TEMPORARY TABLE "OGG"."GGS_TEMP_COLS" ("SEQNO" NUMBER NOT NULL ENABLE, "COLNAME" VARCHAR2(400 BYTE), "NULLABLE" NUMBER, "VIRTUAL" NUMBER, "UDT" NUMBER, "ISSYS" NUMBER) ON COMMIT PRESERVE ROWS

处理对象类型 DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . 导入了 "SCOTT"."DEPT"                              5.093 KB       5 行
. . 导入了 "SCOTT"."EMP"                               5.625 KB      14 行
. . 导入了 "SCOTT"."SALGRADE"                          4.882 KB       5 行
. . 导入了 "SCOTT"."TESTDDL"                           5.382 KB    1000 行
. . 导入了 "SCOTT"."BONUS"                                 0 KB       0 行
处理对象类型 DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
ORA-39083: 对象类型 PACKAGE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE        DDLVersionSpecific AS

CURSOR uk_curs (powner IN VARCHAR2, ptable IN VARCHAR2) IS
    SELECT key.key_name index_name,
                    key.column_name,
                    key.descend
              FROM (SELECT c.constraint_name key_name,
                            c.column_name column_name,
                            c.position position,
                            'ASC' descend
                    FROM dba_cons_columns c
                    WHERE c.owner = powner
                        AND c.table_name = ptable
                        AND c.constraint_name = (
                              SELECT MIN(con1.name) FROM
                                     sys.user$ user1,
                                   sys.user$ user2,
                                     sys.cdef$ cdef,
                                     sys.con$ con1,
                                     sys.con$ con2,
                                     sys.obj$ obj1,
                                     sys.obj$ obj2
                               WHERE user1.name = powner
                                 AND obj1.name = ptable
                                 AND cdef.type# = 3
                                 AND bitand(cdef.defer, 4) = 4
                                 AND cdef.enabled is NOT NULL
                                 AND con2.owner# = user2.user#(+)
                                 AND cdef.robj# = obj2.obj#(+)
                                 AND cdef.rcon# = con2.con#

ORA-39083: 对象类型 PACKAGE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE        DDLReplication AS

    /*
    Note about naming convention for constants:
    MD (metadata) constants
    MK (marker) constants
    NOTE: constant strings can be of any length up to 9(for example 'A1' or 'B2')
    NOTE: constant string cannot start with a digit
    NOTE: constant string cannot contain comma
    they are shortened to one byte or two bytes to produce less bulky output and save space in history tables
    */

    -- metadata columns
    -- IMPORTANT: when adding new ones, add them to tracing reporting routines
    MD_TAB_USERID CONSTANT VARCHAR2 (3) := 'A1';
    MD_COL_NAME CONSTANT VARCHAR2 (3) := 'A2';
    MD_COL_NUM CONSTANT VARCHAR2 (3) := 'A3';
    MD_COL_SEGCOL CONSTANT VARCHAR2 (3) := 'A4';
    MD_COL_TYPE CONSTANT VARCHAR2 (3) := 'A5';
    MD_COL_LEN CONSTANT VARCHAR2 (3) := 'A6';
    MD_COL_ISNULL CONSTANT VARCHAR2 (3) := 'A7';
    MD_COL_PREC CONSTANT VARCHAR2 (3) := 'A8';
    MD_COL_SCALE CONSTANT VARCHAR2 (3) := 'A9';
    MD_COL_CHARSETID CONSTANT VARCHAR2 (3) := 'B1';
    MD_COL_CHARSETFORM CONSTANT VARCHAR2 (3) := 'A';
    MD_COL_ALT_NAME CONSTANT VARCHAR2 (3) := 'C';
    MD_COL_ALT_TYPE CONSTANT VARCHAR2 (3) := 'D';
    MD_COL_ALT_PREC CONSTANT VARCHAR2 (3) := 'E';
    MD_COL_ALT_CHAR_USED CONSTANT VARCHAR2 (3) := 'F';
    MD_COL_ALT_XML_TYPE CONSTANT VARCHAR2 (3) := 'G';
    MD_TAB_COLCOUNT CONSTANT VARCHAR2 (3) := 'H';
    MD_TAB_DATAOBJECTID CONSTANT VARCHAR2 (3) := 'I';
    MD_TAB_CLUCOLS CONSTANT VARCHAR2 (3) := 'J';

ORA-39083: 对象类型 PACKAGE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE       DDLAux AS

TB_IOT CONSTANT NUMBER := 960;
TB_CLUSTER CONSTANT NUMBER := 1024;
TB_NESTED CONSTANT NUMBER := 8192;
TB_TEMP CONSTANT NUMBER := 12582912;
TB_EXTERNAL CONSTANT NUMBER := 2147483648;

TYPE_INDEX CONSTANT NUMBER := 1;
TYPE_TABLE CONSTANT NUMBER := 2;
TYPE_VIEW CONSTANT NUMBER := 4;
TYPE_SYNONYM CONSTANT NUMBER := 5;
TYPE_SEQUENCE CONSTANT NUMBER := 6;
TYPE_PROCEDURE CONSTANT NUMBER := 7;
TYPE_FUNCTION CONSTANT NUMBER := 8;
TYPE_PACKAGE CONSTANT NUMBER := 9;
TYPE_TRIGGER CONSTANT NUMBER := 12;

CMD_CREATE CONSTANT varchar2(10) := 'CREATE';
CMD_DROP CONSTANT varchar2(10) := 'DROP';
CMD_TRUNCATE CONSTANT varchar2(10) := 'TRUNCATE';
CMD_ALTER CONSTANT varchar2(10) := 'ALTER';

/* Add a rule for inclusion or exclusion so that DDL trigger will handle
   * the matching object appropriately. Rules are evaluated in the sorted
   * order (asc) of sno. If the sno is not specified then the rule will be
   * added in the tail end (max(sno) + 1). If the user
   * want to position the rule inbetween two already existing rule
   * could use decimals in between.
   * The users can place rules as 11.1, 11.2 etc.
   * The rules added will be placed in the table GGS_DDL_RULES
   * Rule addition examples
   * To exclude all objects having name like GGS%
   *    addRule(obj_name=> 'GGS%');
   * To exclude all temporary table
   *    addRule(base_obj_property => TB_TEMP, obj_type => TYPE_TABLE);
   * To exclude all External table

ORA-39083: 对象类型 PACKAGE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE        DDLVersionSpecific AS

CURSOR uk_curs (powner IN VARCHAR2, ptable IN VARCHAR2) IS
    SELECT key.key_name index_name,
                    key.column_name,
                    key.descend
              FROM (SELECT c.constraint_name key_name,
                            c.column_name column_name,
                            c.position position,
                            'ASC' descend
                    FROM dba_cons_columns c
                    WHERE c.owner = powner
                        AND c.table_name = ptable
                        AND c.constraint_name = (
                              SELECT MIN(con1.name) FROM
                                     sys.user$ user1,
                                     sys.user$ user2,
                                     sys.cdef$ cdef,
                                     sys.con$ con1,
                                     sys.con$ con2,
                                     sys.obj$ obj1,
                                     sys.obj$ obj2
                               WHERE user1.name = powner
                                 AND obj1.name = ptable
                                 AND cdef.type# = 3
                                 AND bitand(cdef.defer, 4) = 4
                                 AND cdef.enabled is NOT NULL
                                 AND con2.owner# = user2.user#(+)
                                 AND cdef.robj# = obj2.obj#(+)
                                 AND cdef.rcon# = con2.con#

ORA-39083: 对象类型 PACKAGE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE        DDLReplication AS

    /*
    Note about naming convention for constants:
    MD (metadata) constants
    MK (marker) constants
    NOTE: constant strings can be of any length up to 9(for example 'A1' or 'B2')
    NOTE: constant string cannot start with a digit
    NOTE: constant string cannot contain comma
    they are shortened to one byte or two bytes to produce less bulky output and save space in history tables
    */

    -- metadata columns
    -- IMPORTANT: when adding new ones, add them to tracing reporting routines
    MD_TAB_USERID CONSTANT VARCHAR2 (3) := 'A1';
    MD_COL_NAME CONSTANT VARCHAR2 (3) := 'A2';
    MD_COL_NUM CONSTANT VARCHAR2 (3) := 'A3';
    MD_COL_SEGCOL CONSTANT VARCHAR2 (3) := 'A4';
    MD_COL_TYPE CONSTANT VARCHAR2 (3) := 'A5';
    MD_COL_LEN CONSTANT VARCHAR2 (3) := 'A6';
    MD_COL_ISNULL CONSTANT VARCHAR2 (3) := 'A7';
    MD_COL_PREC CONSTANT VARCHAR2 (3) := 'A8';
    MD_COL_SCALE CONSTANT VARCHAR2 (3) := 'A9';
    MD_COL_CHARSETID CONSTANT VARCHAR2 (3) := 'B1';
    MD_COL_CHARSETFORM CONSTANT VARCHAR2 (3) := 'A';
    MD_COL_ALT_NAME CONSTANT VARCHAR2 (3) := 'C';
    MD_COL_ALT_TYPE CONSTANT VARCHAR2 (3) := 'D';
    MD_COL_ALT_PREC CONSTANT VARCHAR2 (3) := 'E';
    MD_COL_ALT_CHAR_USED CONSTANT VARCHAR2 (3) := 'F';
    MD_COL_ALT_XML_TYPE CONSTANT VARCHAR2 (3) := 'G';
    MD_TAB_COLCOUNT CONSTANT VARCHAR2 (3) := 'H';
    MD_TAB_DATAOBJECTID CONSTANT VARCHAR2 (3) := 'I';
    MD_TAB_CLUCOLS CONSTANT VARCHAR2 (3) := 'J';

ORA-39083: 对象类型 PACKAGE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE       DDLAux AS

TB_IOT CONSTANT NUMBER := 960;
TB_CLUSTER CONSTANT NUMBER := 1024;
TB_NESTED CONSTANT NUMBER := 8192;
TB_TEMP CONSTANT NUMBER := 12582912;
TB_EXTERNAL CONSTANT NUMBER := 2147483648;

TYPE_INDEX CONSTANT NUMBER := 1;
TYPE_TABLE CONSTANT NUMBER := 2;
TYPE_VIEW CONSTANT NUMBER := 4;
TYPE_SYNONYM CONSTANT NUMBER := 5;
TYPE_SEQUENCE CONSTANT NUMBER := 6;
TYPE_PROCEDURE CONSTANT NUMBER := 7;
TYPE_FUNCTION CONSTANT NUMBER := 8;
TYPE_PACKAGE CONSTANT NUMBER := 9;
TYPE_TRIGGER CONSTANT NUMBER := 12;

CMD_CREATE CONSTANT varchar2(10) := 'CREATE';
CMD_DROP CONSTANT varchar2(10) := 'DROP';
CMD_TRUNCATE CONSTANT varchar2(10) := 'TRUNCATE';
CMD_ALTER CONSTANT varchar2(10) := 'ALTER';

/* Add a rule for inclusion or exclusion so that DDL trigger will handle
   * the matching object appropriately. Rules are evaluated in the sorted
   * order (asc) of sno. If the sno is not specified then the rule will be
   * added in the tail end (max(sno) + 1). If the user
   * want to position the rule inbetween two already existing rule
   * could use decimals in between.
   * The users can place rules as 11.1, 11.2 etc.
   * The rules added will be placed in the table GGS_DDL_RULES
   * Rule addition examples
   * To exclude all objects having name like GGS%
   *    addRule(obj_name=> 'GGS%');
   * To exclude all temporary table
   *    addRule(base_obj_property => TB_TEMP, obj_type => TYPE_TABLE);
   * To exclude all External table

ORA-39126: 在 KUPW$WORKER.SEND_TRACE_MSG [KUPW: ORA-39083: 对象类型 PACKAGE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE        DDLVersionSpecific AS

CURSOR uk_curs (powner IN VARCHAR2, ptable IN VARCHAR2) IS
    SELECT key.key_name index_name,
                    key.column_name,
                    key.descend
              FROM (SELECT c.constraint_name key_name,
                            c.column_name column_name,
                            c.position position,
                            'ASC' descend
                    FROM dba_cons_columns c
                    WHERE c.owner = powner
                        AND c.table_name = ptable
                        AND c.constraint_name = (
                              SELECT MIN(con1.name) FROM
                                     sys.user$ user1,
                                     sys.user$ user2,
                                     sys.cdef$ cdef,
                                     sys.con$ con1,
                                     sys.con$ con2,
                                     sys.obj$ obj1,
                                     sys.obj$ obj2
                               WHERE user1.name = powner
                                 AND obj1.name = ptable
                                 AND cdef.type# = 3
                                 AND bitand(cdef.defer, 4) = 4
                                 AND cdef.enabled is NOT NULL
                                 AND con2.owner# = user2.user#(+)
                                 AND cdef.robj# = obj2.obj#(+)
                                 AND cdef.rcon# = con2.con#
] 中 Worker 发生意外致命错误
PACKAGE:"OGG"."DDLAUX"
ORA-06502: PL/SQL: 数字或值错误 : 字符串缓

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 12620
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 34278

----- PL/SQL Call Stack -----
object      line object
handle    number name
00007FF97F7656C0     33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FF97F7656C0     12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FF97F7656C0     34341 package body SYS.KUPW$WORKER.SEND_TRACE_MSG
00007FF97F7656C0     28767 package body SYS.KUPW$WORKER.SEND_MSG
00007FF97F7656C0      5418 package body SYS.KUPW$WORKER.LOAD_METADATA
00007FF97F7656C0     13781 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FF97F7656C0      2429 package body SYS.KUPW$WORKER.MAIN
00007FF97F76B538         2 anonymous block

KUPW: In procedure UPDATE_TYPE_COMPLETION_ROW
KUPW: Old Seqno: 255 New Path: PO Num: -6 New Seqno: 0 error count: 1
KUPW: Primary row is: FALSE
KUPW: In SET_HIDDEN_PARAMETER: name = _LOAD_WITHOUT_COMPILE value = NONE
KUPW: ...session altered
KUPW: load without compile cleared
KUPW: Working on old seqno with count of: 3
KUPW: In procedure SEND_MSG. Fatal=0
KUPW: Error count: 3
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小

处理对象类型 DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_errorIsUserCancel
RETURN BOOLEAN
IS
        tmess                 VARCHAR2(32767);
        error_is_user_cancel BOOLEAN := FALSE;
        error_pos             INTEGER := 0;
BEGIN
        tmess := DBMS_UTILITY.format_error_stack;
        error_pos := Instr(tmess, 'ORA-01013: ', 1, 1);
        IF error_pos > 0 THEN
            error_is_user_cancel := TRUE;
        END IF;
        RETURN error_is_user_cancel;
END;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_getAllColsLogging (
                                                             pobjid NUMBER)
RETURN NUMBER
IS
    all_log_group_exists NUMBER;
BEGIN
    BEGIN
        SELECT COUNT(*)
                INTO all_log_group_exists
                FROM sys.obj$ o,sys.cdef$ c
                WHERE
                        o.obj#=pobjid
                        AND o.obj#=c.obj#
                        AND c.type#=17
                        AND rownum=1;

                EXCEPTION
                WHEN OTHERS THEN
                                all_log_group_exists := 0;
        END;
    RETURN all_log_group_exists;
END;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_getErrorStack
RETURN VARCHAR2
IS
        tmess VARCHAR2(32767);
BEGIN
        tmess := DBMS_UTILITY.format_error_backtrace;
        IF length (tmess) > 32767 - 5000 THEN
                tmess := SUBSTR (tmess, 5000); -- just trailing portion
        END IF;
        RETURN tmess;
END;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_verifyDDL
RETURN VARCHAR2
IS
someErr NUMBER;
trigStat VARCHAR2(100);
BEGIN
    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'DDLORA_GETERRORSTACK' AND TYPE = 'FUNCTION';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (1.1)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'CREATE_TRACE' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (2)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'TRACE_PUT_LINE' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (3)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'FILE_SEPARATOR' AND TYPE = 'FUNCTION';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (3.1)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'INITIAL_SETUP' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (4)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND nam

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        file_separator
RETURN CHAR
IS
dump_dir VARCHAR2(400);
errorMessage VARCHAR2(32767);
fileSeparator CHAR := '/';
BEGIN

    SELECT VALUE INTO dump_dir
    FROM sys.v_$parameter
    WHERE name = 'user_dump_dest' ;

      IF instr(dump_dir,'/') > 0 THEN
        fileSeparator := '/';
      ELSIF instr(dump_dir,'\') > 0 THEN
        fileSeparator := '\';
      END IF;

      RETURN fileSeparator;
END file_separator;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        filterDDL (
    stmt IN VARCHAR2,
        ora_owner IN VARCHAR2,
        ora_name IN VARCHAR2,
        ora_objtype IN VARCHAR2,
        ora_optype IN VARCHAR2
)
RETURN VARCHAR2
IS
retVal VARCHAR2(400);
errorMessage VARCHAR2(32767);
BEGIN

    retVal := 'INCLUDE';

        --
        --
        -- DO NOT CUSTOMIZE BEFORE THIS COMMENT
        --
        --

        -- CUSTOMIZE HERE: compute retVal here. It must be either 'INCLUDE' or 'EXCLUDE'.
    -- if it is 'EXCLUDE', DDL will be excluded from DDL trigger processing
    -- and vice versa. Use input parameters to this function to perform this
    -- computation.
    --
    --

    --
    --
    -- DO NOT CUSTOMIZE AFTER THIS COMMENT
    --
    --

    -- intentionally commented out, as it may cause 6508. Use only if needed.
        -- IF "OGG" .DDLReplication.trace_level >= 1 THEN
            -- intentionally commented out, as it may cause 6508. Use only if needed.
            -- "OGG" .trace_put_line ('DDL', 'Returning ' || retVal || ' from filterDDL');
    -- END IF;
        RETURN retVal;

        EXCEPTION
    WHEN OTHERS THEN
        errorMessage := 'filterDDL:' || SQLERRM;
        dbms_output.put_line (errorMessage);
        RAISE;
END;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_errorIsUserCancel
RETURN BOOLEAN
IS
        tmess                 VARCHAR2(32767);
        error_is_user_cancel BOOLEAN := FALSE;
        error_pos             INTEGER := 0;
BEGIN
        tmess := DBMS_UTILITY.format_error_stack;
        error_pos := Instr(tmess, 'ORA-01013: ', 1, 1);
        IF error_pos > 0 THEN
            error_is_user_cancel := TRUE;
        END IF;
      RETURN error_is_user_cancel;
END;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_getAllColsLogging (
                                                             pobjid NUMBER)
RETURN NUMBER
IS
    all_log_group_exists NUMBER;
BEGIN
    BEGIN
        SELECT COUNT(*)
                INTO all_log_group_exists
                FROM sys.obj$ o,sys.cdef$ c
                WHERE
                        o.obj#=pobjid
                        AND o.obj#=c.obj#
                        AND c.type#=17
                        AND rownum=1;

                EXCEPTION
                WHEN OTHERS THEN
                                all_log_group_exists := 0;
        END;
    RETURN all_log_group_exists;
END;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_getErrorStack
RETURN VARCHAR2
IS
        tmess VARCHAR2(32767);
BEGIN
        tmess := DBMS_UTILITY.format_error_backtrace;
        IF length (tmess) > 32767 - 5000 THEN
                tmess := SUBSTR (tmess, 5000); -- just trailing portion
        END IF;
        RETURN tmess;
END;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_verifyDDL
RETURN VARCHAR2
IS
someErr NUMBER;
trigStat VARCHAR2(100);
BEGIN
    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'DDLORA_GETERRORSTACK' AND TYPE = 'FUNCTION';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (1.1)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'CREATE_TRACE' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (2)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'TRACE_PUT_LINE' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (3)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'FILE_SEPARATOR' AND TYPE = 'FUNCTION';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (3.1)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'INITIAL_SETUP' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (4)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND nam

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        file_separator
RETURN CHAR
IS
dump_dir VARCHAR2(400);
errorMessage VARCHAR2(32767);
fileSeparator CHAR := '/';
BEGIN

    SELECT VALUE INTO dump_dir
    FROM sys.v_$parameter
    WHERE name = 'user_dump_dest' ;

      IF instr(dump_dir,'/') > 0 THEN
        fileSeparator := '/';
      ELSIF instr(dump_dir,'\') > 0 THEN
        fileSeparator := '\';
      END IF;

      RETURN fileSeparator;
END file_separator;

ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        filterDDL (
    stmt IN VARCHAR2,
        ora_owner IN VARCHAR2,
        ora_name IN VARCHAR2,
        ora_objtype IN VARCHAR2,
        ora_optype IN VARCHAR2
)
RETURN VARCHAR2
IS
retVal VARCHAR2(400);
errorMessage VARCHAR2(32767);
BEGIN

    retVal := 'INCLUDE';

        --
        --
        -- DO NOT CUSTOMIZE BEFORE THIS COMMENT
        --
        --

        -- CUSTOMIZE HERE: compute retVal here. It must be either 'INCLUDE' or 'EXCLUDE'.
    -- if it is 'EXCLUDE', DDL will be excluded from DDL trigger processing
    -- and vice versa. Use input parameters to this function to perform this
    -- computation.
    --
    --

    --
    --
    -- DO NOT CUSTOMIZE AFTER THIS COMMENT
    --
    --

    -- intentionally commented out, as it may cause 6508. Use only if needed.
        -- IF "OGG" .DDLReplication.trace_level >= 1 THEN
            -- intentionally commented out, as it may cause 6508. Use only if needed.
            -- "OGG" .trace_put_line ('DDL', 'Returning ' || retVal || ' from filterDDL');
    -- END IF;
        RETURN retVal;

        EXCEPTION
    WHEN OTHERS THEN
        errorMessage := 'filterDDL:' || SQLERRM;
        dbms_output.put_line (errorMessage);
        RAISE;
END;

ORA-39126: 在 KUPW$WORKER.SEND_TRACE_MSG [KUPW: ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_verifyDDL
RETURN VARCHAR2
IS
someErr NUMBER;
trigStat VARCHAR2(100);
BEGIN
    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'DDLORA_GETERRORSTACK' AND TYPE = 'FUNCTION';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (1.1)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'CREATE_TRACE' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (2)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'TRACE_PUT_LINE' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (3)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'FILE_SEPARATOR' AND TYPE = 'FUNCTION';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (3.1)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND name = 'INITIAL_SETUP' AND TYPE = 'PROCEDURE';
    IF 0 <> someErr THEN
        RETURN 'ERRORS detected in installation of DDL Replication software components' || ' (4)';
    END IF;

    SELECT COUNT(*) INTO someErr
    FROM dba_errors WHERE owner = 'OGG' AND nam
] 中 Worker 发生意外致命错误
FUNCTION:"OGG"."FILTERDDL"
ORA-06502: PL/SQL: 数字或值错误 : 字符串

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 12620
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 34278

----- PL/SQL Call Stack -----
object      line object
handle    number name
00007FF97F7656C0     33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FF97F7656C0     12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FF97F7656C0     34341 package body SYS.KUPW$WORKER.SEND_TRACE_MSG
00007FF97F7656C0     28767 package body SYS.KUPW$WORKER.SEND_MSG
00007FF97F7656C0      5418 package body SYS.KUPW$WORKER.LOAD_METADATA
00007FF97F7656C0     13781 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FF97F7656C0      2429 package body SYS.KUPW$WORKER.MAIN
00007FF97F76B538         2 anonymous block

KUPW: In SET_HIDDEN_PARAMETER: name = _LOAD_WITHOUT_COMPILE value = NONE
KUPW: ...session altered
KUPW: load without compile cleared
KUPW: Working on old seqno with count of: 6
KUPW: In procedure SEND_MSG. Fatal=0
KUPW: Error count: 6
KUPW: ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_errorIsUserCancel
RETURN BOOLEAN
IS
        tmess                 VARCHAR2(32767);
        error_is_user_cancel BOOLEAN := FALSE;
        error_pos             INTEGER := 0;
BEGIN
        tmess := DBMS_UTILITY.format_error_stack;
        error_pos := Instr(tmess, 'ORA-01013: ', 1, 1);
        IF error_pos > 0 THEN
            error_is_user_cancel := TRUE;
        END IF;
        RETURN error_is_user_cancel;
END;

KUPW: ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_getAllColsLogging (
                                                             pobjid NUMBER)
RETURN NUMBER
IS
    all_log_group_exists NUMBER;
BEGIN
    BEGIN
        SELECT COUNT(*)
                INTO all_log_group_exists
                FROM sys.obj$ o,sys.cdef$ c
                WHERE
                        o.obj#=pobjid
                        AND o.obj#=c.obj#
                        AND c.type#=17
                        AND rownum=1;

                EXCEPTION
                WHEN OTHERS THEN
                                all_log_group_exists := 0;
        END;
    RETURN all_log_group_exists;
END;

KUPW: ORA-39083: 对象类型 FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE FUNCTION        ddlora_getErrorStack
RETURN VARCHAR2
IS
        tmess VARCHAR2(32767);
BEGIN
        tmess := DBMS_UTILITY.format_error_backtrace;
        IF length (tmess) > 32767 - 5000 THEN
                tmess := SUBSTR (tmess, 5000); -- just trailing portion
        END IF;
        RETURN tmess;
END;

KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小

处理对象类型 DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        clear_trace
IS
output_file utl_file.file_type;
errorMessage VARCHAR2(32767);
BEGIN

    utl_file.fremove ('GGS_DDL_TRACE', 'ggs_ddl_trace.log');
EXCEPTION
    WHEN OTHERS THEN
        IF SQLCODE <> - 29283 THEN -- avoid 'file not found'
            errorMessage := 'trace_put_line: ' || ':' || SQLERRM;
            RAISE;
        END IF;
END clear_trace;

ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        create_trace IS
dump_dir VARCHAR2(400);
errorMessage VARCHAR2(32767);
BEGIN

    SELECT VALUE INTO dump_dir
    FROM sys.v_$parameter
    WHERE name = 'user_dump_dest' ;

    EXECUTE IMMEDIATE 'create or replace directory GGS_DDL_TRACE as ''' || dump_dir || '''';

EXCEPTION
    WHEN OTHERS THEN
        errorMessage := 'create_trace: ' || ':' || SQLERRM;
        dbms_output.put_line (errorMessage);
        RAISE;
END create_trace;

ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        ddlora_getLobs (
                                                             powner IN VARCHAR2,
                                                             ptable IN VARCHAR2,
                                                             trueName IN VARCHAR2,
                                                             intcolNum IN NUMBER)
IS
    lobEncrypt VARCHAR2(400);
    lobCompress VARCHAR2(400);
    lobDedup VARCHAR2(400);
    errorMessage VARCHAR2(32767);
BEGIN
    BEGIN
        -- This query can be simplified further if sys.lob$ is used instead,
        -- or if column number is used instead of column name.
        SELECT max(decode(l.encrypt, 'NO', 0, 'NONE', 0, 1)) isEnc,
               max(decode(l.compression, 'NO', 0, 'NONE', 0, 1)) isComp,
               max(decode(l.deduplication, 'NO', 0, 'NONE', 0, 1)) isDedup
          INTO lobEncrypt, lobCompress, lobDedup
          FROM dba_tab_cols c, dba_tab_cols tc, dba_lobs l
          WHERE c.owner = tc.owner AND c.table_name = tc.table_name
            AND c.owner = l.owner AND c.table_name = l.table_name
            AND c.column_id = tc.column_id AND c.qualified_col_name = l.column_name
            AND c.owner = powner AND c.table_name = ptable AND tc.column_name= trueName;

    EXCEPTION
        WHEN OTHERS THEN
            errorMessage := 'get LOB info, error: ' || SQLERRM;
            "OGG" .trace_put_line ('DDL', errorMessage);
            RAISE;
    END;
    DDLReplication.insertToMar

ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        trace_put_line (
                                                        oper VARCHAR2,
                                                        message VARCHAR2)
IS
output_file utl_file.file_type;
errorMessage VARCHAR2(32767);
total_fragments NUMBER;
line_size NUMBER;
prepLine VARCHAR2(32767);
i NUMBER;
BEGIN

    output_file := utl_file.fopen ('GGS_DDL_TRACE', 'ggs_ddl_trace.log', 'A', max_linesize => 32767);
    prepLine := 'SESS ' || USERENV('SESSIONID') || '-' ||
    TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') || ' : ' || oper || ' : ';
    utl_file.put (output_file, prepLine);
    line_size := 900 - lengthb (prepLine) - 1;
    total_fragments := lengthb (message) / line_size + 1;
    IF total_fragments * line_size = lengthb (message) THEN
        total_fragments := total_fragments - 1;
    END IF;

    -- line cannot be bigger than approx 1000 bytes so split it up other
    FOR i IN 1..total_fragments LOOP
        utl_file.put_line (output_file, substrb (message, (i - 1) * line_size + 1, line_size));
    END LOOP;

    utl_file.fCLOSE (output_file);
EXCEPTION
  WHEN OTHERS THEN
        --
        -- If tracing fails, trigger *will not* fail:
        --
        -- closing file can cause an error too, so it's all in vain if we don't check
        BEGIN
            utl_file.fCLOSE (output_file);
        EXCEPTION
            WHEN OTHERS THEN
                NULL;
        END;
        errorMessage := 'trace_put_line: ' || ':' || SQLERRM;
        -- we

ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        clear_trace
IS
output_file utl_file.file_type;
errorMessage VARCHAR2(32767);
BEGIN

    utl_file.fremove ('GGS_DDL_TRACE', 'ggs_ddl_trace.log');
EXCEPTION
    WHEN OTHERS THEN
        IF SQLCODE <> - 29283 THEN -- avoid 'file not found'
            errorMessage := 'trace_put_line: ' || ':' || SQLERRM;
            RAISE;
        END IF;
END clear_trace;

ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        create_trace IS
dump_dir VARCHAR2(400);
errorMessage VARCHAR2(32767);
BEGIN

    SELECT VALUE INTO dump_dir
    FROM sys.v_$parameter
    WHERE name = 'user_dump_dest' ;

    EXECUTE IMMEDIATE 'create or replace directory GGS_DDL_TRACE as ''' || dump_dir || '''';

EXCEPTION
    WHEN OTHERS THEN
        errorMessage := 'create_trace: ' || ':' || SQLERRM;
        dbms_output.put_line (errorMessage);
        RAISE;
END create_trace;

ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        ddlora_getLobs (
                                                             powner IN VARCHAR2,
                                                             ptable IN VARCHAR2,
                                                             trueName IN VARCHAR2,
                                                             intcolNum IN NUMBER)
IS
    lobEncrypt VARCHAR2(400);
    lobCompress VARCHAR2(400);
    lobDedup VARCHAR2(400);
    errorMessage VARCHAR2(32767);
BEGIN
    BEGIN
        -- This query can be simplified further if sys.lob$ is used instead,
        -- or if column number is used instead of column name.
        SELECT max(decode(l.encrypt, 'NO', 0, 'NONE', 0, 1)) isEnc,
               max(decode(l.compression, 'NO', 0, 'NONE', 0, 1)) isComp,
               max(decode(l.deduplication, 'NO', 0, 'NONE', 0, 1)) isDedup
          INTO lobEncrypt, lobCompress, lobDedup
          FROM dba_tab_cols c, dba_tab_cols tc, dba_lobs l
          WHERE c.owner = tc.owner AND c.table_name = tc.table_name
            AND c.owner = l.owner AND c.table_name = l.table_name
            AND c.column_id = tc.column_id AND c.qualified_col_name = l.column_name
            AND c.owner = powner AND c.table_name = ptable AND tc.column_name= trueName;

    EXCEPTION
        WHEN OTHERS THEN
            errorMessage := 'get LOB info, error: ' || SQLERRM;
            "OGG" .trace_put_line ('DDL', errorMessage);
            RAISE;
    END;
    DDLReplication.insertToMar

ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        trace_put_line (
                                                        oper VARCHAR2,
                                                        message VARCHAR2)
IS
output_file utl_file.file_type;
errorMessage VARCHAR2(32767);
total_fragments NUMBER;
line_size NUMBER;
prepLine VARCHAR2(32767);
i NUMBER;
BEGIN

    output_file := utl_file.fopen ('GGS_DDL_TRACE', 'ggs_ddl_trace.log', 'A', max_linesize => 32767);
    prepLine := 'SESS ' || USERENV('SESSIONID') || '-' ||
    TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') || ' : ' || oper || ' : ';
    utl_file.put (output_file, prepLine);
    line_size := 900 - lengthb (prepLine) - 1;
    total_fragments := lengthb (message) / line_size + 1;
    IF total_fragments * line_size = lengthb (message) THEN
        total_fragments := total_fragments - 1;
    END IF;

    -- line cannot be bigger than approx 1000 bytes so split it up other
    FOR i IN 1..total_fragments LOOP
        utl_file.put_line (output_file, substrb (message, (i - 1) * line_size + 1, line_size));
    END LOOP;

    utl_file.fCLOSE (output_file);
EXCEPTION
    WHEN OTHERS THEN
        --
        -- If tracing fails, trigger *will not* fail:
        --
        -- closing file can cause an error too, so it's all in vain if we don't check
        BEGIN
            utl_file.fCLOSE (output_file);
        EXCEPTION
            WHEN OTHERS THEN
                NULL;
        END;
        errorMessage := 'trace_put_line: ' || ':' || SQLERRM;
        -- we

ORA-39126: 在 KUPW$WORKER.SEND_TRACE_MSG [KUPW: ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        ddlora_getLobs (
                                                             powner IN VARCHAR2,
                                                             ptable IN VARCHAR2,
                                                             trueName IN VARCHAR2,
                                                             intcolNum IN NUMBER)
IS
    lobEncrypt VARCHAR2(400);
    lobCompress VARCHAR2(400);
    lobDedup VARCHAR2(400);
    errorMessage VARCHAR2(32767);
BEGIN
    BEGIN
        -- This query can be simplified further if sys.lob$ is used instead,
        -- or if column number is used instead of column name.
        SELECT max(decode(l.encrypt, 'NO', 0, 'NONE', 0, 1)) isEnc,
               max(decode(l.compression, 'NO', 0, 'NONE', 0, 1)) isComp,
               max(decode(l.deduplication, 'NO', 0, 'NONE', 0, 1)) isDedup
          INTO lobEncrypt, lobCompress, lobDedup
          FROM dba_tab_cols c, dba_tab_cols tc, dba_lobs l
          WHERE c.owner = tc.owner AND c.table_name = tc.table_name
            AND c.owner = l.owner AND c.table_name = l.table_name
            AND c.column_id = tc.column_id AND c.qualified_col_name = l.column_name
            AND c.owner = powner AND c.table_name = ptable AND tc.column_name= trueName;

    EXCEPTION
        WHEN OTHERS THEN
            errorMessage := 'get LOB info, error: ' || SQLERRM;
            "OGG" .trace_put_line ('DDL', errorMessage);
            RAISE;
    END;
    DDLReplication.insertToMar
] 中 Worker 发生意外致命错误
PROCEDURE:"OGG"."TRACE_PUT_LINE"
ORA-06502: PL/SQL: 数字或值错误 :

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 12620
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 34278

----- PL/SQL Call Stack -----
object      line object
handle    number name
00007FF97F7656C0     33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FF97F7656C0     12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FF97F7656C0     34341 package body SYS.KUPW$WORKER.SEND_TRACE_MSG
00007FF97F7656C0     28767 package body SYS.KUPW$WORKER.SEND_MSG
00007FF97F7656C0      5418 package body SYS.KUPW$WORKER.LOAD_METADATA
00007FF97F7656C0     13781 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FF97F7656C0      2429 package body SYS.KUPW$WORKER.MAIN
00007FF97F76B538         2 anonymous block

KUPW: Primary row is: FALSE
KUPW: In SET_HIDDEN_PARAMETER: name = _LOAD_WITHOUT_COMPILE value = NONE
KUPW: ...session altered
KUPW: load without compile cleared
KUPW: Working on old seqno with count of: 4
KUPW: In procedure SEND_MSG. Fatal=0
KUPW: Error count: 4
KUPW: ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        clear_trace
IS
output_file utl_file.file_type;
errorMessage VARCHAR2(32767);
BEGIN

    utl_file.fremove ('GGS_DDL_TRACE', 'ggs_ddl_trace.log');
EXCEPTION
    WHEN OTHERS THEN
        IF SQLCODE <> - 29283 THEN -- avoid 'file not found'
            errorMessage := 'trace_put_line: ' || ':' || SQLERRM;
            RAISE;
        END IF;
END clear_trace;

KUPW: ORA-39083: 对象类型 PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PROCEDURE        create_trace IS
dump_dir VARCHAR2(400);
errorMessage VARCHAR2(32767);
BEGIN

    SELECT VALUE INTO dump_dir
    FROM sys.v_$parameter
    WHERE name = 'user_dump_dest' ;

    EXECUTE IMMEDIATE 'create or replace directory GGS_DDL_TRACE as ''' || dump_dir || '''';

EXCEPTION
    WHEN OTHERS THEN
        errorMessage := 'create_trace: ' || ':' || SQLERRM;
        dbms_output.put_line (errorMessage);
        RAISE;
END create_trace;

KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小

处理对象类型 DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
ORA-39083: 对象类型 ALTER_FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER FUNCTION "OGG"."DDLORA_GETERRORSTACK"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

ORA-39083: 对象类型 ALTER_FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER FUNCTION "OGG"."DDLORA_ERRORISUSERCANCEL"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

ORA-39083: 对象类型 ALTER_FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER FUNCTION "OGG"."DDLORA_GETALLCOLSLOGGING"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

ORA-39083: 对象类型 ALTER_FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER FUNCTION "OGG"."FILTERDDL"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

ORA-39083: 对象类型 ALTER_FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER FUNCTION "OGG"."DDLORA_VERIFYDDL"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

ORA-39083: 对象类型 ALTER_FUNCTION 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER FUNCTION "OGG"."FILE_SEPARATOR"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

处理对象类型 DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
ORA-39083: 对象类型 ALTER_PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER PROCEDURE "OGG"."DDLORA_GETLOBS"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:16'

ORA-39083: 对象类型 ALTER_PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER PROCEDURE "OGG"."CREATE_TRACE"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2   PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

ORA-39083: 对象类型 ALTER_PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER PROCEDURE "OGG"."CLEAR_TRACE"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

ORA-39083: 对象类型 ALTER_PROCEDURE 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:

ALTER PROCEDURE "OGG"."TRACE_PUT_LINE"   COMPILE     PLSQL_OPTIMIZE_LEVEL= 2    PLSQL_CODE_TYPE= INTERPRETED    PLSQL_DEBUG= FALSE    PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' NLS_LENGTH_SEMANTICS= BYTE REUSE SETTINGS TIMESTAMP '2022-12-07 22:00:15'

处理对象类型 DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
处理对象类型 DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
ORA-39112: 跳过从属对象类型 CONSTRAINT:"OGG"."SYS_C0011097", 创建基本对象类型 TABLE:"OGG"."GGS_TEMP_COLS" 失败

ORA-39112: 跳过从属对象类型 CONSTRAINT:"OGG"."SYS_C0011101", 创建基本对象类型 TABLE:"OGG"."GGS_STICK" 失败

ORA-39112: 跳过从属对象类型 CONSTRAINT:"OGG"."SYS_C0011099", 创建基本对象类型 TABLE:"OGG"."GGS_TEMP_UK" 失败

处理对象类型 DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
ORA-39083: 对象类型 PACKAGE_BODY 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE BODY        DDLAux AS

FUNCTION addRule(obj_name IN VARCHAR2 DEFAULT NULL,
                   base_obj_name IN VARCHAR2 DEFAULT NULL,
                   owner_name IN VARCHAR2 DEFAULT NULL,
                   base_owner_name IN VARCHAR2 DEFAULT NULL,
                   base_obj_property IN NUMBER DEFAULT NULL,
                   obj_type IN NUMBER DEFAULT NULL,
                   command IN VARCHAR2 DEFAULT NULL,
                   inclusion IN boolean DEFAULT NULL ,
                   sno IN NUMBER DEFAULT NULL)
RETURN NUMBER IS
   new_sno NUMBER;
   cnt NUMBER;
to_include number;
BEGIN
    if inclusion then
    to_include := 1;
    else
    to_include := 0;
    end if;
    BEGIN
      /* If SNO is not specified then find the next SNO automatically */
      IF SNO IS NULL THEN
        BEGIN
          SELECT count(*) ,MAX(SNO) into cnt,NEW_SNO
          FROM "OGG"."GGS_DDL_RULES";

          /* MAX(SNO) + 1 */
          IF cnt = 0 THEN
           NEW_SNO := 1;
          ELSE
           NEW_SNO := NEW_SNO + 1;
          END IF;
        EXCEPTION WHEN OTHERS THEN
          new_sno := 1;
        END;
      ELSE
        NEW_SNO := SNO;
      END IF;

      INSERT INTO "OGG"."GGS_DDL_RULES" VALUES
      (NEW_SNO, OBJ_NAME, OWNER_NAME, BASE_OBJ_NAME, BASE_OWNER_NAME,
       base_obj_PROPERTY, OBJ_TYPE, command, to_include);

      COMMIT;
      RETURN NEW_SNO;
    EXCEPTION WHEN OTHERS THEN
     --dbms_output.put_line (SQLERRM);
     IF "OGG" .DDLReplicati

ORA-39083: 对象类型 PACKAGE_BODY 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE BODY        DDLReplication AS

    /*
    FUNCTION REMOVESQLCOMMENTS RETURNS VARCHAR2
    Remove all SQL comments in DDL (or any SQL). Takes care of dash-dash and slash-star comments.
    Also 'knows' about double and single quoted strings and doesn't remove parts of string if they
    take comment form
    param[in] STMT                           VARCHAR2                SQL to decoment

    return de-commented SQL
    note Statement passed into this function MUST be lesser than 32767 The returned
    statement is NOT correct if SQL is of greater length than that size.
    */
    FUNCTION removeSQLcomments (
                                stmt IN VARCHAR2)
    RETURN VARCHAR2
    IS
    retval VARCHAR2 (32767);
    -- the following (xxxStart) remember if string or comment started (0 not, 1 yes)
    identStart NUMBER := 0;
    stringStart NUMBER := 0;
    slashStart NUMBER := 0;
    dashStart NUMBER := 0;
    beg NUMBER := 0;
    curr NUMBER := 0;
    tryExitLoop NUMBER := 0;
    -- 11833474: We are by default in byte semantics so have
    -- space to accomodate multibyte chars.
    currChar VARCHAR2(5);
    BEGIN
        IF "OGG" .DDLReplication.trace_level >= 1 THEN
           "OGG" .trace_put_line ('DDLTRACE1', 'Entering removeSQLcomments()');
        END IF;

        -- Early out
        IF stmt IS NULL THEN
           return stmt;
        END IF;

        retval := '';
        IF "OGG" .DDLReplication.trace_level >= 1 THEN
                        "OGG" .trace_put_line ('DDLTRA

ORA-39083: 对象类型 PACKAGE_BODY 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE BODY        DDLAux AS

FUNCTION addRule(obj_name IN VARCHAR2 DEFAULT NULL,
                   base_obj_name IN VARCHAR2 DEFAULT NULL,
                   owner_name IN VARCHAR2 DEFAULT NULL,
                   base_owner_name IN VARCHAR2 DEFAULT NULL,
                   base_obj_property IN NUMBER DEFAULT NULL,
                   obj_type IN NUMBER DEFAULT NULL,
                   command IN VARCHAR2 DEFAULT NULL,
                   inclusion IN boolean DEFAULT NULL ,
                   sno IN NUMBER DEFAULT NULL)
RETURN NUMBER IS
   new_sno NUMBER;
   cnt NUMBER;
   to_include number;
BEGIN
    if inclusion then
    to_include := 1;
    else
    to_include := 0;
    end if;
    BEGIN
      /* If SNO is not specified then find the next SNO automatically */
      IF SNO IS NULL THEN
        BEGIN
          SELECT count(*) ,MAX(SNO) into cnt,NEW_SNO
          FROM "OGG"."GGS_DDL_RULES";

          /* MAX(SNO) + 1 */
          IF cnt = 0 THEN
           NEW_SNO := 1;
          ELSE
           NEW_SNO := NEW_SNO + 1;
          END IF;
        EXCEPTION WHEN OTHERS THEN
          new_sno := 1;
        END;
      ELSE
        NEW_SNO := SNO;
      END IF;

      INSERT INTO "OGG"."GGS_DDL_RULES" VALUES
      (NEW_SNO, OBJ_NAME, OWNER_NAME, BASE_OBJ_NAME, BASE_OWNER_NAME,
       base_obj_PROPERTY, OBJ_TYPE, command, to_include);

      COMMIT;
      RETURN NEW_SNO;
    EXCEPTION WHEN OTHERS THEN
     --dbms_output.put_line (SQLERRM);
     IF "OGG" .DDLReplicati

ORA-39083: 对象类型 PACKAGE_BODY 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE BODY        DDLReplication AS

    /*
    FUNCTION REMOVESQLCOMMENTS RETURNS VARCHAR2
    Remove all SQL comments in DDL (or any SQL). Takes care of dash-dash and slash-star comments.
    Also 'knows' about double and single quoted strings and doesn't remove parts of string if they
    take comment form
    param[in] STMT                           VARCHAR2                SQL to decoment

    return de-commented SQL
    note Statement passed into this function MUST be lesser than 32767 The returned
    statement is NOT correct if SQL is of greater length than that size.
    */
    FUNCTION removeSQLcomments (
                                stmt IN VARCHAR2)
    RETURN VARCHAR2
    IS
    retval VARCHAR2 (32767);
    -- the following (xxxStart) remember if string or comment started (0 not, 1 yes)
    identStart NUMBER := 0;
    stringStart NUMBER := 0;
    slashStart NUMBER := 0;
    dashStart NUMBER := 0;
    beg NUMBER := 0;
    curr NUMBER := 0;
    tryExitLoop NUMBER := 0;
    -- 11833474: We are by default in byte semantics so have
    -- space to accomodate multibyte chars.
    currChar VARCHAR2(5);
    BEGIN
        IF "OGG" .DDLReplication.trace_level >= 1 THEN
           "OGG" .trace_put_line ('DDLTRACE1', 'Entering removeSQLcomments()');
        END IF;

        -- Early out
        IF stmt IS NULL THEN
           return stmt;
        END IF;

        retval := '';
        IF "OGG" .DDLReplication.trace_level >= 1 THEN
                        "OGG" .trace_put_line ('DDLTRA

ORA-39126: 在 KUPW$WORKER.SEND_TRACE_MSG [KUPW: ORA-39083: 对象类型 PACKAGE_BODY 创建失败, 出现错误:
ORA-31625: 必须有方案 OGG 才能导入此对象, 但此方案不可访问
ORA-01435: 用户不存在

失败的 sql 为:
CREATE PACKAGE BODY        DDLAux AS

FUNCTION addRule(obj_name IN VARCHAR2 DEFAULT NULL,
                   base_obj_name IN VARCHAR2 DEFAULT NULL,
                   owner_name IN VARCHAR2 DEFAULT NULL,
                   base_owner_name IN VARCHAR2 DEFAULT NULL,
                   base_obj_property IN NUMBER DEFAULT NULL,
                   obj_type IN NUMBER DEFAULT NULL,
                   command IN VARCHAR2 DEFAULT NULL,
                   inclusion IN boolean DEFAULT NULL ,
                   sno IN NUMBER DEFAULT NULL)
RETURN NUMBER IS
   new_sno NUMBER;
   cnt NUMBER;
   to_include number;
BEGIN
    if inclusion then
    to_include := 1;
    else
    to_include := 0;
    end if;
    BEGIN
      /* If SNO is not specified then find the next SNO automatically */
     IF SNO IS NULL THEN
        BEGIN
          SELECT count(*) ,MAX(SNO) into cnt,NEW_SNO
          FROM "OGG"."GGS_DDL_RULES";

          /* MAX(SNO) + 1 */
          IF cnt = 0 THEN
           NEW_SNO := 1;
          ELSE
           NEW_SNO := NEW_SNO + 1;
          END IF;
        EXCEPTION WHEN OTHERS THEN
          new_sno := 1;
        END;
      ELSE
        NEW_SNO := SNO;
      END IF;

      INSERT INTO "OGG"."GGS_DDL_RULES" VALUES
      (NEW_SNO, OBJ_NAME, OWNER_NAME, BASE_OBJ_NAME, BASE_OWNER_NAME,
       base_obj_PROPERTY, OBJ_TYPE, command, to_include);

      COMMIT;
      RETURN NEW_SNO;
    EXCEPTION WHEN OTHERS THEN
     --dbms_output.put_line (SQLERRM);
     IF "OGG" .DDLReplicati
] 中 Worker 发生意外致命错误
PACKAGE_BODY:"OGG"."DDLREPLICATION"
ORA-06502: PL/SQL: 数字或值错误

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 12620
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在 "SYS.KUPW$WORKER", line 34278

----- PL/SQL Call Stack -----
object      line object
handle    number name
00007FF97F7656C0     33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FF97F7656C0     12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FF97F7656C0     34341 package body SYS.KUPW$WORKER.SEND_TRACE_MSG
00007FF97F7656C0     28767 package body SYS.KUPW$WORKER.SEND_MSG
00007FF97F7656C0      5418 package body SYS.KUPW$WORKER.LOAD_METADATA
00007FF97F7656C0     13781 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FF97F7656C0      2429 package body SYS.KUPW$WORKER.MAIN
00007FF97F76B538         2 anonymous block

KUPW: In procedure UPDATE_TYPE_COMPLETION_ROW
KUPW: Old Seqno: 347 New Path: PO Num: -6 New Seqno: 0 error count: 1
KUPW: Primary row is: FALSE
KUPW: In SET_HIDDEN_PARAMETER: name = _LOAD_WITHOUT_COMPILE value = NONE
KUPW: ...session altered
KUPW: load without compile cleared
KUPW: Working on old seqno with count of: 2
KUPW: In procedure SEND_MSG. Fatal=0
KUPW: Error count: 2
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小

处理对象类型 DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
处理对象类型 DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
处理对象类型 DATABASE_EXPORT/AUDIT

作业 "SYSTEM"."SYS_IMPORT_FULL_01" 已经完成, 但是有 239 个错误 (于星期四 12月 22 15:00:17 2022 elapsed 0 00:00:33 完成)

最后修改时间：2025-03-11 16:37:12

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

数据泵批量导出导入非系统用户数据

1、导出

1.1、字符集

1.2、建目录

1.3、编写parfile

1.4、导出作业

2、导入

2.1、目标端字符集

2.2、dmp文件处理

2.3、执行导入

评论