oracle 整库同步报错

最新推荐文章于 2023-08-18 17:23:53 发布

gs80140

最新推荐文章于 2023-08-18 17:23:53 发布

阅读量1.8k

点赞数

本文链接：https://blog.csdn.net/gs80140/article/details/103396332

版权

报错1

ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name
Failing sql is:
CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 26214400,SIZE 524288000 AUTOEXTEND ON NEXT 1048576 MAXSIZE 32767M BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name
Failing sql is:
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE SIZE 68157440 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name
Failing sql is:
CREATE TABLESPACE "USERS" DATAFILE SIZE 5242880,SIZE 524288000 AUTOEXTEND ON NEXT 1048576 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name
Failing sql is:
CREATE TABLESPACE "EHL_PUBLIC_DEFAULT" DATAFILE SIZE 1073741824,SIZE 524288000 AUTOEXTEND ON NEXT 1048576 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name

报错2

CREATE SEQUENCE  "EHL_APPLICATION"."S_T_SVMS_LED"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE 
ORA-39083: Object type SEQUENCE failed to create with error:
ORA-01917: user or role '' does not exist
Failing sql is:
 CREATE SEQUENCE  "EHL_APPLICATION"."S_T_SVMS_MAPLINE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE 
ORA-39083: Object type SEQUENCE failed to create with error:
ORA-01917: user or role '' does not exist
Failing sql is:
 CREATE SEQUENCE  "EHL_APPLICATION"."SEQ_T_SVMS_MESSAGESERVER_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 2 NOCACHE  NOORDER  NOCYCLE 
ORA-39083: Object type SEQUENCE failed to create with error:
ORA-01917: user or role '' does not exist
Failing sql is:

报错3

Failing sql is:
BEGIN 
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'24171450607');COMMIT; END; 
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema EHL_GPS is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
BEGIN 
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'24171450607');COMMIT; END; 
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema EHL_TFM is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
BEGIN 
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'24171450607');COMMIT; END; 
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema EHL_GIS is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
BEGIN 
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'24171450607');COMMIT; END; 
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema EHL_LOG is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
BEGIN

报错4

ORA-39083: Object type TABLE:"EHL_APPLICATION"."T_EVENT_ALARM" failed to create with error:
ORA-01918: user 'EHL_APPLICATION' does not exist
Failing sql is:
CREATE TABLE "EHL_APPLICATION"."T_EVENT_ALARM" ("ALARMID" VARCHAR2(50 BYTE) NOT NULL ENABLE, "SALARMID" VARCHAR2(50 BYTE), "ALARMTIME" DATE NOT NULL ENABLE, "ALARMPERSON" VARCHAR2(30 BYTE), "ALARMPERSONTEL" VARCHAR2(30 BYTE), "INVOLVEDCAR" VARCHAR2(200 BYTE), "RECEIVEPERSONID" VARCHAR2(20 BYTE), "RECEIVEPERSONNAME" VARCHAR2(50 BYTE), "EVENTSOURCE" VARCH
ORA-39083: Object type TABLE:"EHL_ANALYSIS"."T_TIAP_10M_OD_HEATMAP" failed to create with error:
ORA-01918: user 'EHL_ANALYSIS' does not exist
Failing sql is:
CREATE TABLE "EHL_ANALYSIS"."T_TIAP_10M_OD_HEATMAP" ("HID" VARCHAR2(16 BYTE) NOT NULL ENABLE, "RDATE" DATE, "RHOUR" VARCHAR2(2 BYTE), "RMINUTE" VARCHAR2(2 BYTE), "BAYNUMBER" VARCHAR2(10 BYTE), "BAYPROPERTY" VARCHAR2(1 BYTE), "VEHAMOUNT" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_C
ORA-39083: Object type TABLE:"EHL_ANALYSIS"."T_TIAP_5M_BAYONET_CURRENTNUM" failed to create with error:
ORA-01918: user 'EHL_ANALYSIS' does not exist
Failing sql is:
CREATE TABLE "EHL_ANALYSIS"."T_TIAP_5M_BAYONET_CURRENTNUM" ("ID" VARCHAR2(16 BYTE) NOT NULL ENABLE, "KKID" VARCHAR2(16 BYTE), "CURDATE" DATE, "CURHOUR" VARCHAR2(2 BYTE), "CURMINUTE" VARCHAR2(2 BYTE), "CURRENTNUM" NUMBER, "DIR" VARCHAR2(2 BYTE)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_
ORA-39083: Object type TABLE:"EHL_ANALYSIS"."T_TIAP_5M_BAYONET_FLOW_WARNING" failed to create with error:
ORA-01918: user 'EHL_ANALYSIS' does not exist
Failing sql is:
CREATE TABLE "EHL_ANALYSIS"."T_TIAP_5M_BAYONET_FLOW_WARNING" ("ID" VARCHAR2(16 BYTE) NOT NULL ENABLE, "CID" VARCHAR2(50 BYTE), "CURDATE" DATE, "CURHOUR" VARCHAR2(16 BYTE), "CURMINUTE" VARCHAR2(16 BYTE), "DIR" VARCHAR2(2 BYTE), "WARNINGLEVEL" CHAR(1 BYTE), "CURNUM" NUMBER, "BEFORENUM" NUMBER, "DVAL" NUMBER, "UPDATETIME" DATE DEFAULT sysdate) P
ORA-39083: Object type TABLE:"EHL_ANALYSIS"."T_TIAP_5M_BAYONET_TRAVELTIME" failed to create with error:
ORA-01918: user 'EHL_ANALYSIS' does not exist
Failing sql is:
CREATE TABLE "EHL_ANALYSIS"."T_TIAP_5M_BAYONET_TRAVELTIME" ("ID" VARCHAR2(16 BYTE) NOT NULL ENABLE, "GLID" VARCHAR2(16 BYTE), "CURDATE" DATE, "CURHOUR" VARCHAR2(2 BYTE), "CURMINUTE" VARCHAR2(2 BYTE), "TRAVELTIME" NUMBER, "REGIONNO" VARCHAR2(16 BYTE), "STATKK" VARCHAR2(16 BYTE), "ENDKK" VARCHAR2(16 BYTE)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN
ORA-39083: Object type TABLE:"EHL_ANALYSIS"."T_TIAP_VEHICLE_AMOUNT" failed to create with error:
ORA-01918: user 'EHL_ANALYSIS' does not exist
Failing sql is:
CREATE TABLE "EHL_ANALYSIS"."T_TIAP_VEHICLE_AMOUNT" ("AID" VARCHAR2(16 BYTE) NOT NULL ENABLE, "SID" VARCHAR2(16 BYTE), "RECORDDATE" DATE, "RECORDHOUR" VARCHAR2(2 BYTE), "RECORDMINUTE" VARCHAR2(2 BYTE), "BELONGTO" VARCHAR2(6 BYTE), "AMOUNT" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLAS
ORA-39083: Object type TABLE:"EHL_ANALYSIS"."T_TIAP_VEHICLE_TOTAL_AMOUNT" failed to create with error:
ORA-01918: user 'EHL_ANALYSIS' does not exist
Failing sql is:
CREATE TABLE "EHL_ANALYSIS"."T_TIAP_VEHICLE_TOTAL_AMOUNT" ("AID" VARCHAR2(16 BYTE) NOT NULL ENABLE, "SID" VARCHAR2(16 BYTE), "RECORDDATE" DATE, "RECORDHOUR" VARCHAR2(2 BYTE), "RECORDMINUTE" VARCHAR2(2 BYTE), "BELONGTO" VARCHAR2(6 BYTE), "AMOUNT" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAU
ORA-39083: Object type TABLE:"EHL_APPLICATION"."T_IN_TVMR_VIOLATION" failed to create with error:
ORA-01918: user 'EHL_APPLICATION' does not exist
Failing sql is:
Failing sql is:
CREATE TABLE "EHL_APPLICATION"."T_IN_TVMR_VIOLATION" ("SBBH" VARCHAR2(20 BYTE), "VIOLATION_XH" VARCHAR2(32 BYTE) NOT NULL ENABLE, "XH" VARCHAR2(14 BYTE), "HPHM" VARCHAR2(15 BYTE) NOT NULL ENABLE, "HPZL" VARCHAR2(7 BYTE) NOT NULL ENABLE, "WFXW" VARCHAR2(7 BYTE) NOT NULL ENABLE, "WFSJ" DATE NOT NULL ENABLE, "WFDD" VARCHAR2(13 BYTE) NOT NULL ENABLE, 
ORA-39083: Object type TABLE:"EHL_TFM"."T_IN_TICS_DETECTOR_1M_DATA" failed to create with error:
ORA-01918: user 'EHL_TFM' does not exist
Failing sql is:
CREATE TABLE "EHL_TFM"."T_IN_TICS_DETECTOR_1M_DATA" ("DETECTORID" VARCHAR2(20 BYTE), "DETECTORTYPE" VARCHAR2(20 BYTE), "DETCODE" VARCHAR2(15 BYTE), "DATETIME" DATE, "VOLUME" NUMBER(10,2), "SPEED" NUMBER(5,2), "TIMEOPY" NUMBER(5,2), "HEADTIME" NUMBER(5,2), "HEADDISTANCE" NUMBER(5,2), "QUELENGTH" NUMBER(5,2), "SATURATION" NUMBER(5,2), "DENSITY" NUMBER(5,2), 
ORA-39083: Object type TABLE:"EHL_TFM"."T_IN_TICS_DETECTOR_5M_DATA" failed to create with error:
ORA-01918: user 'EHL_TFM' does not exist
Failing sql is:
CREATE TABLE "EHL_TFM"."T_IN_TICS_DETECTOR_5M_DATA" ("DETECTORID" VARCHAR2(20 BYTE), "DETECTORTYPE" VARCHAR2(20 BYTE), "DETCODE" VARCHAR2(10 BYTE), "DATETIME" DATE, "VOLUME" NUMBER(10,2), "SPEED" NUMBER(5,2), "TIMEOPY" NUMBER(5,2), "HEADTIME" NUMBER(5,2), "HEADDISTANCE" NUMBER(5,2), "QUELENGTH" NUMBER(5,2), "SATURATION" NUMBER(5,2), "DENSITY" NUMBER(5,2), 
ORA-

ailing sql is:
CREATE TABLE "EHL_PUBLIC"."T_BASE_ROADITEM" ("GLBM" VARCHAR2(12 BYTE) NOT NULL ENABLE, "DLDM" VARCHAR2(6 BYTE) NOT NULL ENABLE, "XZQH" VARCHAR2(512 BYTE), "DLMC" VARCHAR2(64 BYTE) NOT NULL ENABLE, "DLLX" VARCHAR2(2 BYTE), "GLXZDJ" VARCHAR2(1 BYTE), "DX" VARCHAR2(1 BYTE), "DLXX" VARCHAR2(2 BYTE), "LKLDLX" VARCHAR2(2 BYTE), "DLWLGL" VARCHAR2(1 BYTE), "LMJG" VARCH
ORA-39083: Object type TABLE:"EHL_PUBLIC"."T_OMS_DLPS" failed to create with error:
ORA-01918: user 'EHL_PUBLIC' does not exist
Failing sql is:
CREATE TABLE "EHL_PUBLIC"."T_OMS_DLPS" ("DLPID" NUMBER, "DLPNAME" VARCHAR2(36 BYTE)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "EHL_PUBLIC_DEFAULT" 
ORA-39083: Object type TABLE:"EHL_PUBLIC"."T_SYS_DEPARTMENT" failed to create with error:
ORA-01918: user 'EHL_PUBLIC' does not exist
Failing sql is:
CREATE TABLE "EHL_PUBLIC"."T_SYS_DEPARTMENT" ("JGID" VARCHAR2(12 BYTE) NOT NULL ENABLE, "JGMC" VARCHAR2(100 BYTE) NOT NULL ENABLE, "JGCCBM" VARCHAR2(20 BYTE), "XZJB" VARCHAR2(3 BYTE), "JGZN" VARCHAR2(200 BYTE), "YWMS" VARCHAR2(200 BYTE), "JGLX" VARCHAR2(200 BYTE), "SCDZ" VARCHAR2(200 BYTE), "YZBM" VARCHAR2(6 BYTE), "BZRS" VARCHAR2(10 BYTE), "ZBMJS" VARCHAR2(10
ORA-39083: Object type TABLE:"EHL_PUBLIC"."T_OMS_VGA" failed to create with error:
ORA-01918: user 'EHL_PUBLIC' does not exist
Failing sql is:
CREATE TABLE "EHL_PUBLIC"."T_OMS_VGA" ("ID" VARCHAR2(50 BYTE) NOT NULL ENABLE, "NAME" VARCHAR2(100 BYTE), "ARRAY" VARCHAR2(10 BYTE), "MESSAGEIP" VARCHAR2(50 BYTE), "DEPARTMENTNUM" VARCHAR2(20 BYTE)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "EHL_PUBLIC_DEFAULT" 
ORA-39083: Object type TABLE:"EHL_PUBLIC"."T_OMS_MASTER" failed to create with error:
ORA-01918: user 'EHL_PUBLIC' does not exist
Failing sql is:
CREATE TABLE "EHL_PUBLIC"."T_OMS_MASTER" ("MASTERID" VARCHAR2(30 BYTE) NOT NULL ENABLE, "MASTERTYPE" VARCHAR2(30 BYTE), "MASTERNAME" VARCHAR2(100 BYTE), "PIPETYPE" VARCHAR2(30 BYTE), "COMPORT" NUMBER, "BAUDRATE" NUMBER, "PARITY" VARCHAR2(15 BYTE), "REMOTEIP" VARCHAR2(15 BYTE), "REMOTEPORT" NUMBER, "USERNAME" VARCHAR2(100 BYTE), "PASSWORD" VARCHAR2(100 BYTE), "CANC
ORA-39083: Object type TABLE:"EHL_PUBLIC"."T_IN_OMS_TGSINFO" failed to create with error:
ORA-01918: user 'EHL_PUBLIC' does not exist
Failing sql is:
CREATE TABLE "EHL_PUBLIC"."T_IN_OMS_TGSINFO" ("KDID" VARCHAR2(20 BYTE) NOT NULL ENABLE, "KKMC" VARCHAR2(100 BYTE) NOT NULL ENABLE, "FBDX" VARCHAR2(20 BYTE), "SSDL" VARCHAR2(5 BYTE), "SSJGID" VARCHAR2(20 BYTE), "KKLX" VARCHAR2(7 BYTE), "DDMS" VARCHAR2(200 BYTE), "CDS" VARCHAR2(32 BYTE)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOC
ORA-39083: Object type TABLE:"EHL_PUBLIC"."T_IN_OMS_PDA" failed to create with error:
ORA-01918: user 'EHL_PUBLIC' does not exist
Failing sql is:
CREATE TABLE "EHL_PUBLIC"."T_IN_OMS_PDA" ("ID" VARCHAR2(32 BYTE) NOT NULL ENABLE, "GLJG" VARCHAR2(12 BYTE) NOT NULL ENABLE, "SBBH" VARCHAR2(20 BYTE) NOT NULL ENABLE, "PP" VARCHAR2(128 BYTE), "FZR" VARCHAR2(30 BYTE), "LXFS" VARCHAR2(30 BYTE), "ZCSJ" DATE, "ZT" CHAR(1 BYTE) DEFAULT 1, "SIMNO" VARCHAR2(30 BYTE), "GXSJ" DATE NOT NULL ENABLE, "DHHM" VARCHAR2(15 BYTE), 
ORA-39083: Object type TABLE:"EHL_PUBLIC"."T_IN_OMS_LED" failed to create with error:
ORA-01918: user 'EHL_PUBLIC' does not exist
Failing sql is:
CREATE TABLE "EHL_PUBLIC"."T_IN_OMS_LED" ("JLBH" VARCHAR2(36 BYTE) NOT NULL ENABLE, "PTLX" VARCHAR2(7 BYTE) NOT NULL ENABLE, "PTSC" VARCHAR2(7 BYTE) NOT NULL ENABLE, "KZFS" VARCHAR2(7 BYTE) NOT NULL ENABLE, "ZCPBZ" VARCHAR2(7 BYTE), "GLZPBH" VARCHAR2(20 BYTE), "YT" VARCHAR2(7 BYTE) NOT NULL ENABLE, "PK" NUMBER(6,0) NOT NULL ENABLE, "PG" NUMBER(6,0) NOT NULL ENABLE
ORA-39083: Object type TABLE:"EHL_PUBLIC"."T_IN_OMS_EQUIP" failed to create with error:
ORA-01918: user 'EHL_PUBLIC' does not exist
Failing sql is:

报错5

ORA-39083: Object type PACKAGE failed to create with error:
ORA-31625: Schema EHL_LOG is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE PACKAGE PKG_VERSION_MANAGE
AS
  PROCEDURE PRO_VERSION_CHECK(
      SUB_SYS_NAME_STR VARCHAR2,
      VERSION_STR      VARCHAR2);
  PROCEDURE PRO_VERSION_APPEND(
      SUB_SYS_NAME_STR VARCHAR2,
      VERSION_STR      VARCHAR2);
END P
ORA-39083: Object type PACKAGE failed to create with error:
ORA-31625: Schema EHL_TFM is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE PACKAGE DATAARCHIVE AS
  /**********************************
  *¹¦Ĝû³ƣº½»ͨÁ÷1·֖ӵʽ¾ݔʼÁ÷Á¿ʽ¾ݹ鵵
  *¹¦Ĝèʶ£º½»ͨÁ÷1·֖ӵʽ¾ݔʼÁ÷Á¿ʽ¾ݹ鵵
  *¸üЂȕƚ£º2016-05-19
  *¸üЂȋ£ºHouXiaoGang
  ******************************
ORA-39083: Object type PACKAGE failed to create with error:
ORA-31625: Schema EHL_TFM is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE package DATATRANSFORM is
  /**********************************
  *¹¦Ĝû³ƣº½»ͨÁ÷Á÷Á¿ʽ¾ݗª»»£¨¸øΞν˹´«µ݊ý¾݊±ת»»£©
  *¹¦Ĝèʶ£º½»ͨÁ÷1·֖ӯr5·֖ӔʼÁ÷Á¿ʽ¾ݗª»»ΪΞν˹ШҪµĸ񊽊  *¸üЂȕƚ£º2016-09-22
  *¸üЂȋ£ºHouXiaoGan
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
















ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE FUNCTION F_GET_DEPT(CODE_VALUE IN VARCHAR2)
  RETURN VARCHAR2
  IS
  SNAME VARCHAR2(500):='';
  SCODE_VALUES VARCHAR2(20);
  NCOUNT NUMBER(5);
  SPACE VARCHAR2(2):='';

  BEGIN
    IF LENGTH(CODE_VALUE)=0 OR NVL(CODE_VALUE,'~')=
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE function f_get_encrypt(Arg_Instr In Varchar2,Raw_Key In Varchar2) Return Varchar2 Is
  /*
   description: ʚȨ«ɺ³ɹ攲£¨Ξν˹̡¹©£©
   author£ºwujun
   date£º2016.5.10
  */
  Encrypt_Key Varchar2(256);
	Begin
    Encrypt_Key 
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE FUNCTION F_GET_FULLDEPT(CODE_VALUE IN VARCHAR2)
  RETURN VARCHAR2
  IS
  SNAME VARCHAR2(500):='';
  SPARENTNAME VARCHAR2(500):='';
  SCODE_VALUES VARCHAR2(20);
  SGRADE VARCHAR2(20);
  SPACE VARCHAR2(2):='';
  NCOUNT NUMBER(5);
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE FUNCTION F_GET_NAME(SITEM_N IN VARCHAR2,CODE_VALUE IN VARCHAR2)
  RETURN VARCHAR2
  IS
  SNAME VARCHAR2(500):='';
  SCODE_VALUES VARCHAR2(20);
  NCOUNT NUMBER(5);
  SPACE VARCHAR2(2):='';

  BEGIN
    IF LENGTH(CODE_VALUE)=0 OR 
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE FUNCTION F_GET_PARENT(CODE IN VARCHAR2)
  RETURN VARCHAR2
  IS
  SZERO VARCHAR2(1);
  NZEROS NUMBER(5);
  SRESULT VARCHAR2(50);
  BEGIN
    SRESULT:='';
    NZEROS:=0;
    IF LENGTH(CODE)=0 OR NVL(CODE,'~')='~' THEN
       RETUR
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE FUNCTION F_GET_PERSON(CODE_VALUE IN VARCHAR2)
  RETURN VARCHAR2
  IS
  SNAME VARCHAR2(30):='';
  SCODE_VALUES VARCHAR2(20);
  NCOUNT NUMBER(5);
  SPACE VARCHAR2(2):='';

  BEGIN
    IF LENGTH(CODE_VALUE)=0 OR NVL(CODE_VALUE,'~')
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE function f_get_raw_key Return Varchar2 Is
   /*
     description: ʚȨ«ɺ³ɹ攲£¨Ξν˹̡¹©£©
     author£ºwujun
     date£º2016.5.10
   */
    Raw_Key Raw(32);
    i          Int;
    Key_String1 Char(1) := 'L';
    Key_String
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_ANALYSIS is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE function f_get_ITGS_name2(sitem_n in varchar2,code_value in varchar2)
  return varchar2
  is
  sname varchar2(500);

  BEGIN
    select dmsm into sname from t_itgs_code where dmlb=sitem_n and dm=code_value;
    return (sname);
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_ANALYSIS is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE function F_GET_LAST_ZXBK(zxlx in varchar2) return number is
  --רϮ±຅
  zhbh number;
  --Υ·¨´Ίý
  wfcs number;
  --
  itemcount number;

begin

  select max(zxbh)
    into zhbh
    from T_ITGS_SUSPECT_SPECIAL
   where bkl
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_ANALYSIS is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE function f_get_minsbbh(code_value in varchar2)
  return varchar2
  is
  sname varchar2(500):='';
  scode_values varchar2(100);
  ncount number(10);
  space varchar2(2):='';

  BEGIN
   -- if length(code_value)=0 or nvl(code_va
ORA-39083: Object type FUNCTION failed to create with error:
ORA-31625: Schema EHL_ANALYSIS is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:
CREATE function f_get_tgsname(code_value in varchar2)
  return varchar2
  is
  sname varchar2(500):='';
  scode_values varchar2(20);
  ncount number(5);
  space varchar2(2):='';

  BEGIN
    if length(code_value)=0 or nvl(code_value,
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT



ALTER FUNCTION "EHL_PUBLIC"."F_GET_DEPT"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-27 14:22:16'
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_PUBLIC"."F_GET_FULLDEPT"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-27 14:22:16'
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_PUBLIC"."F_GET_NAME"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-27 14:22:16'
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_PUBLIC"."F_GET_PARENT"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-27 14:22:16'
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_PUBLIC"."F_GET_PERSON"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-27 14:22:16'
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_ANALYSIS is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_ANALYSIS"."F_GET_ITGS_NAME2"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-27 15:0
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_ANALYSIS is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_ANALYSIS"."F_GET_TGSNAME"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-27 15:07:2
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_ANALYSIS is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_ANALYSIS"."F_GET_LAST_ZXBK"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-27 15:07
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_PUBLIC"."F_GET_RAW_KEY"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-28 10:29:04'
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_PUBLIC"."F_GET_ENCRYPT"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-28 10:29:04'
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_PUBLIC is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_PUBLIC"."F_CREATE_JKXLH"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-04-28 10:29:04'
ORA-39083: Object type ALTER_FUNCTION failed to create with error:
ORA-31625: Schema EHL_ANALYSIS is needed to import this object, but is unaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7614
ORA-01435: user does not exist
Failing sql is:

ALTER FUNCTION "EHL_ANALYSIS"."F_GET_MINSBBH"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2018-10-18 23:06:4
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX

报错6

RA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_FRAME_DICTINFO_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_FRAME_DICTINFO" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_FRAME_LOG_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_FRAME_LOG" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_CODE_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_CODE" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_CODETYPE_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_CODETYPE" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_CODE_SUB_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_CODE_SUB" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_DATAPRIV_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_DATAPRIV" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_FUNC_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_FUNC" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_LOG_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_LOG" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_PARA_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_PARA" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_PRIV_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_PRIV" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_PRIVDATA_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_PRIVDATA" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_PRIVFUNC_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_PRIVFUNC" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_USER_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_USER" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_USERDATAPRIV_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_USERDATAPRIV" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."T_SYS_USERPRIV_PK" skipped, base object type TABLE:"EHL_PUBLIC"."T_SYS_USERPRIV" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."PK_T_OMS_CODE_ID" skipped, base object type TABLE:"EHL_PUBLIC"."T_OMS_CODE" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."PK_T_TFM_DETECTOR" skipped, base object type TABLE:"EHL_PUBLIC"."T_TFM_DETECTOR" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_BYTEAR_DEPL" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_GE_BYTEARRAY" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_MODEL_SOURCE" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RE_MODEL" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_MODEL_SOURCE_EXTRA" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RE_MODEL" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_MODEL_DEPLOYMENT" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RE_MODEL" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_EXE_SUPER" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_EXECUTION" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_EXE_PROCDEF" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_EXECUTION" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_EXEC_BUSKEY" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_EXECUTION" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_EXE_PROCINST" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_EXECUTION" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_EXE_PARENT" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_EXECUTION" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_JOB_EXCEPTION" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_JOB" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_UNIQ_PROCDEF" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RE_PROCDEF" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_TASK_EXEC" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_TASK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_TASK_PROCINST" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_TASK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_TASK_PROCDEF" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_TASK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_TASK_CREATE" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_TASK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_TSKASS_TASK" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_IDENTITYLINK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_ATHRZ_PROCEDEF" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_IDENTITYLINK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_IDL_PROCINST" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_IDENTITYLINK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_IDENT_LNK_USER" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_IDENTITYLINK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_IDENT_LNK_GROUP" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_IDENTITYLINK" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_VAR_EXE" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_VARIABLE" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_VAR_PROCINST" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_VARIABLE" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_VAR_BYTEARRAY" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_VARIABLE" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_VARIABLE_TASK_ID" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_VARIABLE" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_EVENT_SUBSCR" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_EVENT_SUBSCR" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_EVENT_SUBSCR_CONFIG_" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_RU_EVENT_SUBSCR" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_HI_PRO_INST_END" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_HI_PROCINST" creation failed
ORA-39112: Dependent object type INDEX:"EHL_PUBLIC"."ACT_IDX_HI_PRO_I_BUSKEY" skipped, base object type TABLE:"EHL_PUBLIC"."ACT_HI_PROCINST" creation failed
ORA-39112: Dependent ob

报错7

ORA-31685: Object type MATERIALIZED_VIEW:"SYSMAN"."MGMT_ECM_MD_ALL_TBL_COLUMNS" failed due to insufficient privileges. Failing sql is:
CREATE MATERIALIZED VIEW "SYSMAN"."MGMT_ECM_MD_ALL_TBL_COLUMNS" ("METADATA_ID", "TARGET_TYPE", "SNAPSHOT_TYPE", "TABLE_NAME", "NAME", "UI_NAME", "TYPE", "TYPE_FORMAT", "UI_ON", "COMPARE_ON", "COMPARE_UI_ON", "HISTORY_ON", "HISTORY_UI_ON", "IS_KEY", "IS_CONTEXT", "IS_SUMMARY", "IS_CHILD_LINK", "LINK_COLUMN_NAME", "COL_ORDER", "SOURCE_TABLE_NAME") USING ("MGMT_ECM_MD_ALL_TBL_C
Processing object type DATABASE_EXPORT/SCHEMA/JOB
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
 BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 4001, LUSER=> 'SYS', PUSER=> 'APEX_030200', CUSER=> 'APEX_030200', NEXT_DATE=> TO_DATE('2019-07-16 21:48:36', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 8/24', BROKEN=>  FALSE, WHAT=> 'wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs => 24);', NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURR
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
 BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 4002, LUSER=> 'SYS', PUSER=> 'APEX_030200', CUSER=> 'APEX_030200', NEXT_DATE=> TO_DATE('2019-07-16 14:37:32', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 10/1440', BROKEN=>  FALSE, WHAT=> 'wwv_flow_mail.push_queue(wwv_flow_platform.get_preference(''SMTP_HOST_ADDRESS''),wwv_flow_platform.get_preference(''SMTP_HOST_PORT''));', NLSENV=> 'NLS_LANGUA
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
 BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 3, LUSER=> 'EHL_TFM', PUSER=> 'EHL_TFM', CUSER=> 'EHL_TFM', NEXT_DATE=> TO_DATE('2019-07-16 14:40:00', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'trunc(sysdate,''mi'') + 60/1440', BROKEN=>  FALSE, WHAT=> 'BEGIN
	DATAARCHIVE.ORIGINALDATAARCHIVE1M(SYSDATE);
	COMMIT ;
END;', NLSENV=> 'NLS_LANGUAGE=''SIMPLIFIED CHINESE'' NLS_TERRITORY=''CHINA'' NLS_CURRENCY=
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
 BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 4, LUSER=> 'EHL_TFM', PUSER=> 'EHL_TFM', CUSER=> 'EHL_TFM', NEXT_DATE=> TO_DATE('2019-07-16 14:40:00', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'trunc(sysdate,''mi'') + 60/1440', BROKEN=>  FALSE, WHAT=> 'BEGIN
	DATAARCHIVE.ORIGINALDATAARCHIVE5M(SYSDATE);
	COMMIT ;
END;', NLSENV=> 'NLS_LANGUAGE=''SIMPLIFIED CHINESE'' NLS_TERRITORY=''CHINA'' NLS_CURRENCY=
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
 BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 5, LUSER=> 'EHL_TFM', PUSER=> 'EHL_TFM', CUSER=> 'EHL_TFM', NEXT_DATE=> TO_DATE('2019-07-16 14:37:00', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'trunc(sysdate,''mi'') + 1/1440', BROKEN=>  FALSE, WHAT=> 'BEGIN
	                    DATATRANSFORM.TRANSFORM1MTEMPDATA(SYSDATE)	;
	                    COMMIT ;
                            END;', NLSENV=> 'NLS_L
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
 BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 6, LUSER=> 'EHL_TFM', PUSER=> 'EHL_TFM', CUSER=> 'EHL_TFM', NEXT_DATE=> TO_DATE('2019-07-16 14:37:00', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'trunc(sysdate,''hh24'') + (floor(to_char(sysdate,''mi'')/5) * 5 + 7)/1440', BROKEN=>  FALSE, WHAT=> 'begin
                      DATATRANSFORM.TRANSFORM5MTEMPDATA( sysdate) ;
                      commit ;
    
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
 BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 23, LUSER=> 'SYS', PUSER=> 'SYSMAN', CUSER=> 'SYSMAN', NEXT_DATE=> TO_DATE('2019-07-16 14:36:37', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 1 / (24 * 60)', BROKEN=>  FALSE, WHAT=> 'EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();', NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS_NUM
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT
Job "SYS"."SYS_IMPORT_FULL_01" completed with 12247 error(s) at Thu Dec 5 01:42:57 2019 elapsed 0 00:01:39

1,需要检查下这个用户是否有读写 directory gps的权限，如果没有权限，进行如下类似授权操作：
SQL> grant write,read on DIRECTORY EXP_TC to user;
Grant succeeded.

2,检查user用户是否拥有DBA或IMP_FULL_DATABASE权限，这些都需要检查下。
SQL> Select * from SESSION_ROLES order by ROLE;
SQL> grant IMP_FULL_DATABASE to user;
Grant succeeded.