C:\Users\> expdp system/system123@testhist full=y transportable=always directory=DB_PUMP dumpfile=testhist_tts.dmp metrics=y exclude=statistics compression=all logfile=testhist_tts_export.log Export: Release 12.1.0.2.0 - Production on Tue Nov 9 10:09:46 2021 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/********@ucashist full=y transportable=always directory=DB_PUMP dumpfile=ucashist_tts.dmp metrics=y exclude=statistics compression=a ll logfile=ucashist_tts_export.log Startup took 4 seconds Estimate in progress using BLOCKS method... Processing object type DATABASE_EXPORT/PLUGTS_FULL/FULL/PLUGTS_TABLESPACE Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK Completed 1 PLUGTS_BLK objects in 0 seconds Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA Estimated 1 TABLE_DATA objects in 1 seconds Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA Estimated 64 TABLE_DATA objects in 2 seconds Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA Estimated 10 TABLE_DATA objects in 0 seconds Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA Estimated 0 TABLE_DATA objects in 23 seconds Total estimation using BLOCKS method: 4.265 MB Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER Completed 1 MARKER objects in 1 seconds Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER Completed 1 MARKER objects in 0 seconds Processing object type DATABASE_EXPORT/TABLESPACE Completed 1 TABLESPACE objects in 0 seconds Processing object type DATABASE_EXPORT/PROFILE Completed 1 PROFILE objects in 0 seconds Processing object type DATABASE_EXPORT/SYS_USER/USER Completed 1 USER objects in 0 seconds Processing object type DATABASE_EXPORT/SCHEMA/USER Completed 2 USER objects in 0 seconds Processing object type DATABASE_EXPORT/RADM_FPTM Completed 1 RADM_FPTM objects in 0 seconds Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT Completed 6 PROC_SYSTEM_GRANT objects in 2 seconds Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT Completed 4 SYSTEM_GRANT objects in 0 seconds Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT Completed 3 ROLE_GRANT objects in 0 seconds Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE Completed 10 DEFAULT_ROLE objects in 0 seconds Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT Completed 7 ON_USER_GRANT objects in 0 seconds Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA Completed 1 TABLESPACE_QUOTA objects in 0 seconds Processing object type DATABASE_EXPORT/RESOURCE_COST Completed 1 RESOURCE_COST objects in 0 seconds Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK Completed 1 DB_LINK objects in 0 seconds Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK Completed 1 TRUSTED_DB_LINK objects in 0 seconds Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY Completed 2 DIRECTORY objects in 0 seconds Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT Completed 4 OBJECT_GRANT objects in 4 seconds Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM Completed 3 PROCACT_SYSTEM objects in 7 seconds Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ Completed 23 PROCOBJ objects in 6 seconds Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM Completed 2 PROCACT_SYSTEM objects in 1 seconds Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA Completed 16 PROCACT_SCHEMA objects in 1 seconds Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE Completed 1 TABLE objects in 12 seconds Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER Completed 1 MARKER objects in 3 seconds Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE Completed 64 TABLE objects in 29 seconds Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE Completed 10 TABLE objects in 30 seconds Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER Completed 1 MARKER objects in 3 seconds Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE Completed 64 TABLE objects in 16 seconds Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT Completed TABLE objects in seconds Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE Completed 8 PROCEDURE objects in 1 seconds Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE Completed 8 ALTER_PROCEDURE objects in 2 seconds Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX Completed 3 INDEX objects in 1 seconds Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT Completed 3 CONSTRAINT objects in 1 seconds Processing object type DATABASE_EXPORT/END_PLUGTS_BLK Completed 1 PLUGTS_BLK objects in 3 seconds Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER Completed 1 MARKER objects in 0 seconds Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ Completed 4 PROCOBJ objects in 2 seconds Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA Completed 4 PROCACT_SCHEMA objects in 2 seconds Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE Completed 2 AUDIT_POLICY_ENABLE objects in 1 seconds Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER Completed 1 MARKER objects in 0 seconds . . exported "SYS"."KU$_USER_MAPPING_VIEW" 5.289 KB 37 rows in 1 seconds . . exported "ORDDATA"."ORDDCM_DOCS" 57.28 KB 9 rows in 1 seconds . . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5 KB 8 rows in 0 seconds . . exported "LBACSYS"."OLS$DIP_EVENTS" 4.867 KB 2 rows in 0 seconds . . exported "LBACSYS"."OLS$INSTALLATIONS" 5.234 KB 2 rows in 0 seconds . . exported "LBACSYS"."OLS$PROPS" 5.125 KB 5 rows in 0 seconds . . exported "SYS"."DAM_CONFIG_PARAM$" 5.117 KB 14 rows in 0 seconds . . exported "SYS"."TSDP_PARAMETER$" 4.929 KB 1 rows in 0 seconds . . exported "SYS"."TSDP_POLICY$" 4.898 KB 1 rows in 0 seconds . . exported "SYS"."TSDP_SUBPOL$" 4.984 KB 1 rows in 0 seconds . . exported "SYSTEM"."REDO_DB" 7.281 KB 1 rows in 0 seconds . . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$ENV_VARS$" 4.976 KB 3 rows in 0 seconds . . exported "WMSYS"."WM$EVENTS_INFO$" 4.960 KB 12 rows in 0 seconds . . exported "WMSYS"."WM$HINT_TABLE$" 5.835 KB 75 rows in 0 seconds . . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$NEXTVER_TABLE$" 5.015 KB 1 rows in 0 seconds . . exported "WMSYS"."WM$REMOVED_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 4.953 KB 1 rows in 0 seconds . . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$WORKSPACES_TABLE$" 5.960 KB 1 rows in 1 seconds . . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 5.179 KB 10 rows in 0 seconds . . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$POL" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$USER" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows in 0 seconds . . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows in 0 seconds . . exported "SYS"."AUD$" 0 KB 0 rows in 0 seconds . . exported "SYS"."DAM_CLEANUP_EVENTS$" 0 KB 0 rows in 0 seconds . . exported "SYS"."DAM_CLEANUP_JOBS$" 0 KB 0 rows in 0 seconds . . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows in 0 seconds . . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows in 0 seconds . . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows in 0 seconds . . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows in 0 seconds . . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows in 0 seconds . . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows in 0 seconds . . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows in 0 seconds . . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows in 0 seconds . . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows in 0 seconds . . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 5.804 KB 12 rows in 0 seconds . . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 4.921 KB 2 rows in 1 seconds . . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows in 0 seconds . . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows in 0 seconds . . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows in 0 seconds . . exported "SYS"."NACL$_ACE_EXP" 5.726 KB 1 rows in 1 seconds . . exported "SYS"."NACL$_HOST_EXP" 5.132 KB 1 rows in 0 seconds . . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows in 0 seconds . . exported "WMSYS"."WM$EXP_MAP" 5.273 KB 3 rows in 1 seconds Completed 1 DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 1 seconds Completed 64 DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA objects in 2 seconds Completed 10 DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 3 seconds Completed 0 DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA objects in 0 seconds Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded ***************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is: E:\UCAS_BACKUP\TESTHIST_TTS.DMP ****************************************************************************** Datafiles required for transportable tablespace UCAS_DATA: H:\MISAPP1\ORADATA_2\TESTHIST\TEST_DATA_01.DBF H:\MISAPP1\ORADATA_2\TESTHIST\TEST_DATA_02.DBF Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Tue Nov 9 10:12:47 2021 elapsed 0 00:02:55 C:\Users\> [oracle@test-machine02 admin]$ impdp system/ucas123@testhist directory=DB_PUMP dumpfile=TESTHIST_TTS.DMP logfile=TESTHIST_TTS_IMP.log metrics=y transport_datafiles='/data01/oradata_2/testhist/TEST_DATA_01.DBF','/data01/oradata_2/testhist/TEST_DATA_02.DBF' Import: Release 19.0.0.0.0 - Production on Wed Feb 2 17:07:10 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. UDI-28002: operation generated ORACLE error 28002 ORA-28002: the password will expire within 4 days Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production W-1 Startup took 0 seconds W-1 Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded W-1 Source time zone is -05:00 and target time zone is +03:00. Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/********@ucashist directory=DB_PUMP dumpfile=UCASHIST_TTS.DMP logfile=UCASHIST_TTS_IMP.log metrics=y transport_datafiles=/data01/oradata_2/ucashist/UCAS_DATA_01.DBF,/data01/oradata_2/ucashist/UCAS_DATA_02.DBF W-1 Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK W-1 Completed 1 PLUGTS_BLK objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/TABLESPACE ORA-31684: Object type TABLESPACE:"TEMP" already exists W-1 Completed 1 TABLESPACE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/PROFILE W-1 Completed 1 PROFILE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SYS_USER/USER ORA-31685: Object type USER:"SYS" failed due to insufficient privileges. Failing sql is: ALTER USER "SYS" IDENTIFIED BY VALUES 'S: ;H: ;T: ; ' TEMPORARY TABLESPACE "TEMP" W-1 Completed 1 USER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/USER ORA-31684: Object type USER:"PDB_ADMIN" already exists W-1 Completed 2 USER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/RADM_FPTM W-1 Completed 1 RADM_FPTM objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT ORA-39083: Object type PROC_SYSTEM_GRANT failed to create with error: ORA-00942: table or view does not exist Failing sql is: BEGIN execute immediate ('CREATE TABLE TEMP_JAVA_PRIVS AS SELECT KIND, GRANTEE, TYPE_SCHEMA, TYPE_NAME, NAME, ACTION, ENABLED FROM DBA_JAVA_POLICY WHERE ROWNUM > 1');COMMIT; END; W-1 Completed 6 PROC_SYSTEM_GRANT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT W-1 Completed 4 SYSTEM_GRANT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT W-1 Completed 3 ROLE_GRANT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE ORA-39083: Object type DEFAULT_ROLE:"MDDATA" failed to create with error: ORA-01918: user 'MDDATA' does not exist Failing sql is: ALTER USER "MDDATA" DEFAULT ROLE ALL ORA-39083: Object type DEFAULT_ROLE:"SPATIAL_WFS_ADMIN_USR" failed to create with error: ORA-01918: user 'SPATIAL_WFS_ADMIN_USR' does not exist Failing sql is: ALTER USER "SPATIAL_WFS_ADMIN_USR" DEFAULT ROLE ALL ORA-39083: Object type DEFAULT_ROLE:"SPATIAL_CSW_ADMIN_USR" failed to create with error: ORA-01918: user 'SPATIAL_CSW_ADMIN_USR' does not exist Failing sql is: ALTER USER "SPATIAL_CSW_ADMIN_USR" DEFAULT ROLE ALL ORA-39083: Object type DEFAULT_ROLE:"FLOWS_FILES" failed to create with error: ORA-01918: user 'FLOWS_FILES' does not exist Failing sql is: ALTER USER "FLOWS_FILES" DEFAULT ROLE ALL ORA-39083: Object type DEFAULT_ROLE:"APEX_PUBLIC_USER" failed to create with error: ORA-01918: user 'APEX_PUBLIC_USER' does not exist Failing sql is: ALTER USER "APEX_PUBLIC_USER" DEFAULT ROLE ALL ORA-39083: Object type DEFAULT_ROLE:"APEX_040200" failed to create with error: ORA-01918: user 'APEX_040200' does not exist Failing sql is: ALTER USER "APEX_040200" DEFAULT ROLE ALL W-1 Completed 10 DEFAULT_ROLE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT ORA-39083: Object type ON_USER_GRANT failed to create with error: ORA-01917: user or role 'APEX_040200' does not exist Failing sql is: GRANT INHERIT PRIVILEGES ON USER "SYS" TO "APEX_040200" ORA-39083: Object type ON_USER_GRANT failed to create with error: ORA-31625: Schema OLAPSYS is needed to import this object, but is unaccessible ORA-01435: user does not exist Failing sql is: GRANT INHERIT PRIVILEGES ON USER "OLAPSYS" TO "PUBLIC" W-1 Completed 7 ON_USER_GRANT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA ORA-39083: Object type TABLESPACE_QUOTA:"FLOWS_FILES" failed to create with error: ORA-01918: user 'FLOWS_FILES' does not exist Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "FLOWS_FILES" QUOTA UNLIMITED ON "SYSAUX"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''SYSAUX'' AND CONTENTS = ''TEMPORARY'''; EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT; IF TEMP_COUNT = 1 THEN RETURN; ELSE RAISE; END IF; ELSE RAISE; END IF;END; W-1 Completed 1 TABLESPACE_QUOTA objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/RESOURCE_COST W-1 Completed 1 RESOURCE_COST objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK W-1 Completed 1 DB_LINK objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK W-1 Completed 1 TRUSTED_DB_LINK objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY ORA-31684: Object type DIRECTORY:"DB_PUMP" already exists W-1 Completed 2 DIRECTORY objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT W-1 Completed 4 OBJECT_GRANT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM W-1 Completed 3 PROCACT_SYSTEM objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ W-1 Completed 23 PROCOBJ objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM ORA-39083: Object type PROCACT_SYSTEM failed to create with error: ORA-01917: user or role 'DV_OWNER' does not exist Failing sql is: BEGIN SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON DBMS_RLS TO "DV_OWNER"');COMMIT; END; W-1 Completed 2 PROCACT_SYSTEM objects in 26 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-31625: Schema OLAPSYS 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=>'UCASHIST', inst_scn=>'14354288573');COMMIT; END; ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-31625: Schema MDDATA 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=>'UCASHIST', inst_scn=>'14354288573');COMMIT; END; ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-31625: Schema SPATIAL_WFS_ADMIN_USR 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=>'UCASHIST', inst_scn=>'14354288573');COMMIT; END; ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-31625: Schema SPATIAL_CSW_ADMIN_USR 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=>'UCASHIST', inst_scn=>'14354288573');COMMIT; END; ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-31625: Schema FLOWS_FILES 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=>'UCASHIST', inst_scn=>'14354288573');COMMIT; END; ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-31625: Schema APEX_PUBLIC_USER 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=>'UCASHIST', inst_scn=>'14354288573');COMMIT; END; ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-31625: Schema APEX_040200 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=>'UCASHIST', inst_scn=>'14354288573');COMMIT; END; W-1 Completed 16 PROCACT_SCHEMA objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE W-1 Completed 1 TABLE objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA W-1 . . imported "SYS"."KU$_EXPORT_USER_MAP" 5.289 KB 37 rows in 0 seconds using direct_path W-1 Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE ORA-39342: Internal error - failed to import internal objects tagged with LABEL_SECURITY due to ORA-01918: user 'LBACSYS' does not exist . ORA-39083: Object type TABLE:"LBACSYS"."OLS$POL" failed to create with error: Failing sql is: CREATE TABLE "LBACSYS"."OLS$POL" ("POL#" NUMBER, "POL_NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE, "COLUMN_NAME" VARCHAR2(128 BYTE) NOT NULL ENABLE, "PACKAGE" VARCHAR2(30 BYTE) NOT NULL ENABLE, "POL_ROLE" VARCHAR2(30 BYTE) NOT NULL ENABLE, "OPTIONS" NUMBER, "FLAGS" NUMBER NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$POLS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$POLS" ("POL#" NUMBER NOT NULL ENABLE, "OWNER" VARCHAR2(128 BYTE) NOT NULL ENABLE, "OPTIONS" NUMBER, "FLAGS" NUMBER) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$POLT" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$POLT" ("POL#" NUMBER NOT NULL ENABLE, "TBL_NAME" VARCHAR2(128 BYTE) NOT NULL ENABLE, "OWNER" VARCHAR2(128 BYTE) NOT NULL ENABLE, "PREDICATE" VARCHAR2(256 BYTE), "FUNCTION" VARCHAR2(1024 BYTE), "OPTIONS" NUMBER, "FLAGS" NUMBER) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$PROFILE" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$PROFILE" ("PROFID" NUMBER, "POL#" NUMBER NOT NULL ENABLE, "MAX_READ" VARCHAR2(4000 BYTE), "MAX_WRITE" VARCHAR2(4000 BYTE), "MIN_WRITE" VARCHAR2(4000 BYTE), "DEF_READ" VARCHAR2(4000 BYTE), "DEF_WRITE" VARCHAR2(4000 BYTE), "DEF_ROW" VARCHAR2(4000 BYTE), "PRIVS" NUMBER) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$USER" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$USER" ("POL#" NUMBER NOT NULL ENABLE, "USR_NAME" VARCHAR2(1024 BYTE) NOT NULL ENABLE, "PROFID" NUMBER NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$PROG" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$PROG" ("POL#" NUMBER NOT NULL ENABLE, "PGM_NAME" VARCHAR2(128 BYTE) NOT NULL ENABLE, "OWNER" VARCHAR2(128 BYTE) NOT NULL ENABLE, "PRIVS" NUMBER) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$LAB" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$LAB" ("TAG#" NUMBER(10,0), "POL#" NUMBER NOT NULL ENABLE, "NLABEL" NUMBER(10,0) NOT NULL ENABLE, "SLABEL" VARCHAR2(4000 BYTE) NOT NULL ENABLE, "ILABEL" VARCHAR2(4000 BYTE) NOT NULL ENABLE, "FLAGS" NUMBER NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$POLICY_ADMIN" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$POLICY_ADMIN" ("ADMIN_DN" VARCHAR2(1024 BYTE) NOT NULL ENABLE, "POLICY_NAME" VARCHAR2(128 BYTE) NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$INSTALLATIONS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$INSTALLATIONS" ("COMPONENT" VARCHAR2(30 BYTE), "DESCRIPTION" VARCHAR2(500 BYTE), "VERSION" VARCHAR2(64 BYTE), "BANNER" VARCHAR2(80 BYTE), "INSTALLED" DATE) 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 "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$PROPS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$PROPS" ("NAME" VARCHAR2(128 BYTE), "VALUE$" VARCHAR2(4000 BYTE), "COMMENT$" VARCHAR2(4000 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 "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$SESSINFO" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$SESSINFO" ("KEY" VARCHAR2(32 BYTE) NOT NULL ENABLE, "INST_NUMBER" NUMBER, "USERID" NUMBER, "SID" NUMBER, "SERIAL#" NUMBER, "STARTUP_TIME" DATE, "TYPE" NUMBER(*,0), "NAME" VARCHAR2(1024 BYTE), "STRVALUE1" VARCHAR2(4000 BYTE), "STRVALUE2" VARCHAR2(4000 BYTE), "STRVALUE3" VARCHAR2(4000 BYTE), "NUMVALUE1" NUMBER(*,0), "NUMVALUE2" NUMBER(*,0)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$LEVELS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$LEVELS" ("POL#" NUMBER NOT NULL ENABLE, "LEVEL#" NUMBER(4,0) NOT NULL ENABLE, "CODE" VARCHAR2(30 BYTE) NOT NULL ENABLE, "NAME" VARCHAR2(80 BYTE) NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$COMPARTMENTS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$COMPARTMENTS" ("POL#" NUMBER NOT NULL ENABLE, "COMP#" NUMBER(4,0) NOT NULL ENABLE, "CODE" VARCHAR2(30 BYTE) NOT NULL ENABLE, "NAME" VARCHAR2(80 BYTE) NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$GROUPS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$GROUPS" ("POL#" NUMBER NOT NULL ENABLE, "GROUP#" NUMBER(4,0) NOT NULL ENABLE, "CODE" VARCHAR2(30 BYTE) NOT NULL ENABLE, "NAME" VARCHAR2(80 BYTE) NOT NULL ENABLE, "PARENT#" NUMBER(4,0)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$USER_LEVELS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$USER_LEVELS" ("POL#" NUMBER NOT NULL ENABLE, "USR_NAME" VARCHAR2(1024 BYTE) NOT NULL ENABLE, "MAX_LEVEL" NUMBER(4,0), "MIN_LEVEL" NUMBER(4,0), "DEF_LEVEL" NUMBER(4,0), "ROW_LEVEL" NUMBER(4,0)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$USER_COMPARTMENTS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$USER_COMPARTMENTS" ("POL#" NUMBER NOT NULL ENABLE, "USR_NAME" VARCHAR2(1024 BYTE) NOT NULL ENABLE, "COMP#" NUMBER(4,0) NOT NULL ENABLE, "RW_ACCESS" NUMBER(2,0) NOT NULL ENABLE, "DEF_COMP" VARCHAR2(1 BYTE) DEFAULT 'Y' NOT NULL ENABLE, "ROW_COMP" VARCHAR2(1 BYTE) DEFAULT 'Y' NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$USER_GROUPS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$USER_GROUPS" ("POL#" NUMBER NOT NULL ENABLE, "USR_NAME" VARCHAR2(1024 BYTE) NOT NULL ENABLE, "GROUP#" NUMBER(4,0) NOT NULL ENABLE, "RW_ACCESS" NUMBER(2,0) NOT NULL ENABLE, "DEF_GROUP" VARCHAR2(1 BYTE) DEFAULT 'Y' NOT NULL ENABLE, "ROW_GROUP" VARCHAR2(1 BYTE) DEFAULT 'Y' NOT NULL ENABLE) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$PROFILES" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$PROFILES" ("POLICY_NAME" VARCHAR2(128 BYTE) NOT NULL ENABLE, "PROFILE_NAME" VARCHAR2(128 BYTE) NOT NULL ENABLE, "MAX_READ_LABEL" VARCHAR2(4000 BYTE), "MAX_WRITE_LABEL" VARCHAR2(4000 BYTE), "MIN_WRITE_LABEL" VARCHAR2(4000 BYTE), "DEF_READ_LABEL" VARCHAR2(4000 BYTE), "DEF_ROW_LABEL" VARCHAR2(4000 BYTE), "PRIVS" VARCHAR2(256 BYTE)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$DIP_DEBUG" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$DIP_DEBUG" ("EVENT_ID" VARCHAR2(32 BYTE) NOT NULL ENABLE, "OBJECTDN" VARCHAR2(1024 BYTE) NOT NULL ENABLE, "OLS_OPERATION" VARCHAR2(50 BYTE)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$DIP_EVENTS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$DIP_EVENTS" ("EVENT_ID" VARCHAR2(32 BYTE) NOT NULL ENABLE, "PURPOSE" VARCHAR2(40 BYTE) NOT NULL ENABLE) 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 "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$AUDIT" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$AUDIT" ("POL#" NUMBER NOT NULL ENABLE, "USR_NAME" VARCHAR2(128 BYTE) NOT NULL ENABLE, "OPTION#" NUMBER, "SUCCESS" NUMBER, "FAILURE" NUMBER, "SUC_TYPE" NUMBER, "FAIL_TYPE" NUMBER, "OPTION_PRIV#" NUMBER, "SUCCESS_PRIV" NUMBER, "FAILURE_PRIV" NUMBER, "SUC_PRIV_TYPE" NUMBER, "FAIL_PRIV_TYPE" NUMBER) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "SYSTEM" ORA-39083: Object type TABLE:"LBACSYS"."OLS$AUDIT_ACTIONS" failed to create with error: ORA-01918: user 'LBACSYS' does not exist Failing sql is: CREATE TABLE "LBACSYS"."OLS$AUDIT_ACTIONS" ("ACTION#" NUMBER NOT NULL ENABLE, "NAME" VARCHAR2(40 BYTE) NOT NULL ENABLE) 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 "SYSTEM" ORA-39342: Internal error - failed to import internal objects tagged with ORDIM due to ORA-01918: user 'ORDDATA' does not exist . ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_DOCS" failed to create with error: Failing sql is: CREATE TABLE "ORDDATA"."ORDDCM_DOCS" ("DOC_ID" NUMBER(*,0), "DOC_NAME" VARCHAR2(100 CHAR) NOT NULL ENABLE, "DOC_TYPE_ID" NUMBER NOT NULL ENABLE, "DOC_CONTENT" "SYS"."XMLTYPE" NOT NULL ENABLE, "ORACLE_INSTALL" NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, "CREATE_DATE" DATE DEFAULT SYSDATE NOT NULL ENABLE) 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 "SYSAUX" XMLTYPE COLUMN "DOC_CONTENT" STORE AS SECUREFILE BINARY XML ( TABLESPACE "SYSAUX" ENABLE STORAGE IN ROW CHUNK 8192 NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ALLOW NONSCHEMA DISALLOW ANYSCHEMA W-1 Completed 64 TABLE objects in 6 seconds W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA W-1 . . imported "WMSYS"."E$CONSTRAINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$LOCKROWS_INFO$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$UDTRIG_INFO$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM$" 5.117 KB 14 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_PARAMETER$" 4.929 KB 1 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_POLICY$" 4.898 KB 1 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_SUBPOL$" 4.984 KB 1 rows in 0 seconds using direct_path W-1 . . imported "SYSTEM"."REDO_DB_TMP" 7.281 KB 1 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$CONS_COLUMNS$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$ENV_VARS$" 4.976 KB 3 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$EVENTS_INFO$" 4.960 KB 12 rows in 1 seconds using direct_path W-1 . . imported "WMSYS"."E$HINT_TABLE$" 5.835 KB 75 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$MODIFIED_TABLES$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$NESTED_COLUMNS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$NEXTVER_TABLE$" 5.015 KB 1 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$REMOVED_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$RIC_LOCKING_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$RIC_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$RIC_TRIGGERS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$VERSION_HIERARCHY_TABLE$" 4.953 KB 1 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$VERSION_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$VT_ERRORS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$WORKSPACES_TABLE$" 5.960 KB 1 rows in 1 seconds using external_table W-1 . . imported "WMSYS"."E$WORKSPACE_PRIV_TABLE$" 5.179 KB 10 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."AMGT$DP$AUD$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_ASSOCIATION$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_CONDITION$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_FEATURE_POLICY$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_PROTECTION$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_SENSITIVE_DATA$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_SENSITIVE_TYPE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$TSDP_SOURCE$" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYSTEM"."REDO_LOG_TMP" 0 KB 0 rows in 0 seconds using direct_path W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE W-1 Completed 10 TABLE objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA W-1 . . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYSTEM"."SCHEDULER_PROGRAM_ARGS_TMP" 5.804 KB 12 rows in 15 seconds using external_table W-1 . . imported "SYS"."AMGT$DP$AUDTAB$TBS$FOR_EXPORT" 4.921 KB 2 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$DBA_SENSITIVE_DATA" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."DP$DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."AMGT$DP$FGA_LOG$FOR_EXPORT" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "SYS"."NACL$_ACE_IMP" 5.726 KB 1 rows in 0 seconds using direct_path W-1 . . imported "SYS"."NACL$_HOST_IMP" 5.132 KB 1 rows in 0 seconds using direct_path W-1 . . imported "SYS"."NACL$_WALLET_IMP" 0 KB 0 rows in 0 seconds using direct_path W-1 . . imported "WMSYS"."E$EXP_MAP" 5.273 KB 3 rows in 0 seconds using direct_path W-1 Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER W-1 Completed 1 MARKER objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE W-1 Completed 64 TABLE objects in 5 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE W-1 Completed 8 PROCEDURE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE W-1 Completed 8 ALTER_PROCEDURE objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX W-1 Completed 3 INDEX objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT W-1 Completed 3 CONSTRAINT objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/END_PLUGTS_BLK W-1 Completed 1 PLUGTS_BLK objects in 1 seconds W-1 Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 6 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ ORA-39083: Object type PROCOBJ failed to create with error: ORA-31625: Schema APEX_040200 is needed to import this object, but is unaccessible ORA-01435: user does not exist Failing sql is: BEGIN dbms_scheduler.create_job('"ORACLE_APEX_PURGE_SESSIONS"', job_type=>'STORED_PROCEDURE', job_action=> 'WWV_FLOW_CACHE.PURGE_SESSIONS' , number_of_arguments=>0, start_date=>TO_TIMESTAMP_TZ('11-SEP-2014 10.52.53.152000000 AM -05:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=> 'FREQ=HOURLY;BYMINUTE=0' , end_date=>NULL, job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments=> NULL ); dbms_scheduler.enable('"ORACLE_APEX_PURGE_SESSIONS"');COMMIT; END; ORA-39083: Object type PROCOBJ failed to create with error: ORA-31625: Schema APEX_040200 is needed to import this object, but is unaccessible ORA-01435: user does not exist Failing sql is: BEGIN dbms_scheduler.create_job('"ORACLE_APEX_MAIL_QUEUE"', job_type=>'STORED_PROCEDURE', job_action=> 'WWV_FLOW_MAIL.PUSH_QUEUE_IMMEDIATE' , number_of_arguments=>0, start_date=>TO_TIMESTAMP_TZ('11-SEP-2014 10.52.53.612000000 AM -05:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=> 'FREQ=MINUTELY;BYMINUTE=0,5,10,15,20,25,30,35,40,45,50,55;BYSECOND=0' , end_date=>NULL, job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments=> NULL ); dbms_scheduler.enable('"ORACLE_APEX_MAIL_QUEUE"');COMMIT; END; ORA-39083: Object type PROCOBJ failed to create with error: ORA-31625: Schema APEX_040200 is needed to import this object, but is unaccessible ORA-01435: user does not exist Failing sql is: BEGIN dbms_scheduler.create_job('"ORACLE_APEX_WS_NOTIFICATIONS"', job_type=>'STORED_PROCEDURE', job_action=> 'WWV_FLOW_WORKSHEET_API.DO_NOTIFY' , number_of_arguments=>0, start_date=>TO_TIMESTAMP_TZ('11-SEP-2014 10.52.53.617000000 AM -05:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=> 'FREQ=MINUTELY;BYMINUTE=0,30;BYSECOND=0' , end_date=>NULL, job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments=> NULL ); dbms_scheduler.enable('"ORACLE_APEX_WS_NOTIFICATIONS"');COMMIT; END; ORA-39083: Object type PROCOBJ failed to create with error: ORA-31625: Schema APEX_040200 is needed to import this object, but is unaccessible ORA-01435: user does not exist Failing sql is: BEGIN dbms_scheduler.create_job('"ORACLE_APEX_DAILY_MAINTENANCE"', job_type=>'STORED_PROCEDURE', job_action=> 'WWV_FLOW_MAINT.DAILY_MAINTENANCE' , number_of_arguments=>0, start_date=>TO_TIMESTAMP_TZ('11-SEP-2014 10.52.55.378000000 AM -05:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=> 'FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0' , end_date=>NULL, job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments=> NULL ); dbms_scheduler.enable('"ORACLE_APEX_DAILY_MAINTENANCE"');COMMIT; END; W-1 Completed 4 PROCOBJ objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA W-1 Completed 4 PROCACT_SCHEMA objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE W-1 Completed 2 AUDIT_POLICY_ENABLE objects in 0 seconds W-1 Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER W-1 Completed 1 MARKER objects in 1 seconds W-1 Completed 1 DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 0 seconds W-1 Completed 64 DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA objects in 1273 seconds W-1 Completed 10 DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 15 seconds Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" completed with 51 error(s) at Wed Feb 2 17:09:21 2022 elapsed 0 00:02:07