[oracle@machine1 lab03]$ impdp dumpfile=LAB02_FULL_%U.dmp directory=LAB02FULL logfile=LAB02_FULL.log full=y parallel=2 Import: Release 12.1.0.2.0 - Production on Sat Jan 23 17:20:53 2021 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba 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 Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_FULL_01": /******** AS SYSDBA dumpfile=LAB02_FULL_%U.dmp directory=LAB02FULL logfile=LAB02_FULL.log full=y parallel=2 Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/TABLESPACE ORA-31684: Object type TABLESPACE:"TBLS3" already exists ORA-31684: Object type TABLESPACE:"TBLS1" already exists ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists ORA-31684: Object type TABLESPACE:"TBLS4" already exists ORA-31684: Object type TABLESPACE:"TEMP3" already exists ORA-31684: Object type TABLESPACE:"TBLS2" already exists ORA-31684: Object type TABLESPACE:"TS1" already exists ORA-31684: Object type TABLESPACE:"TBLS5" already exists ORA-31684: Object type TABLESPACE:"BIGTBS" already exists ORA-31684: Object type TABLESPACE:"USERS" already exists ORA-31684: Object type TABLESPACE:"USERTBS" already exists Processing object type DATABASE_EXPORT/PROFILE ORA-31684: Object type PROFILE:"TEST1" already exists ORA-31684: Object type PROFILE:"APP_PROFILE" already exists Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABASE_EXPORT/SCHEMA/USER ORA-31684: Object type USER:"TESTUSER" already exists ORA-31684: Object type USER:"TESTUSER1" already exists ORA-31684: Object type USER:"TESTUSER2" already exists Processing object type DATABASE_EXPORT/ROLE ORA-31684: Object type ROLE:"TEST_ROLE" already exists Processing object type DATABASE_EXPORT/RADM_FPTM 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/ON_USER_GRANT 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/DIRECTORY/DIRECTORY ORA-31684: Object type DIRECTORY:"TESTUSER4" already exists ORA-31684: Object type DIRECTORY:"TESTUSER3" already exists ORA-31684: Object type DIRECTORY:"PREUPGRADE_DIR" already exists ORA-31684: Object type DIRECTORY:"LAB02FULL" already exists Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM >>> Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropped and recreated. See My Oracle Support article number 1380295.1. 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/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA . . imported "SYS"."KU$_EXPORT_USER_MAP" 5.835 KB 22 rows Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA . . imported "SYS"."AMGT$DP$AUD$" 0 KB 0 rows . . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS$" 0 KB 0 rows . . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS$" 0 KB 0 rows . . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM$" 6.531 KB 14 rows . . imported "SYS"."DP$TSDP_ASSOCIATION$" 0 KB 0 rows . . imported "SYS"."DP$TSDP_CONDITION$" 0 KB 0 rows . . imported "SYS"."DP$TSDP_FEATURE_POLICY$" 0 KB 0 rows . . imported "SYS"."DP$TSDP_PARAMETER$" 5.953 KB 1 rows . . imported "SYS"."DP$TSDP_POLICY$" 5.921 KB 1 rows . . imported "SYS"."DP$TSDP_PROTECTION$" 0 KB 0 rows . . imported "SYS"."DP$TSDP_SENSITIVE_DATA$" 0 KB 0 rows . . imported "SYS"."DP$TSDP_SENSITIVE_TYPE$" 0 KB 0 rows . . imported "SYS"."DP$TSDP_SOURCE$" 0 KB 0 rows . . imported "SYS"."DP$TSDP_SUBPOL$" 6.328 KB 1 rows . . imported "SYSTEM"."REDO_DB_TMP" 25.59 KB 1 rows . . imported "SYSTEM"."REDO_LOG_TMP" 0 KB 0 rows Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA . . imported "SYS"."AMGT$DP$FGA_LOG$FOR_EXPORT" 0 KB 0 rows . . imported "SYS"."AMGT$DP$AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows . . imported "SYS"."DP$DBA_SENSITIVE_DATA" 0 KB 0 rows . . imported "SYS"."DP$DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows . . imported "SYS"."NACL$_ACE_IMP" 9.929 KB 1 rows . . imported "SYS"."NACL$_HOST_IMP" 6.914 KB 1 rows . . imported "SYS"."NACL$_WALLET_IMP" 0 KB 0 rows . . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP" 8.671 KB 4 rows . . imported "SYSTEM"."SCHEDULER_PROGRAM_ARGS_TMP" 10.21 KB 22 rows Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE ORA-39151: Table "TESTUSER1"."RECORDS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER"."TEST1" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER1"."TABLE2" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER1"."DEPARTMENT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER1"."TABLE5" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER"."TEST" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER1"."TABLE1" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER"."SUMAN" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER1"."HR" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER1"."STUDENT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip ORA-39151: Table "TESTUSER1"."TABLE6" exists. All dependent metadata and data will be skipped due to table_exists_action of skip Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA . . imported "TESTUSER4"."OBJECTS" 1.964 MB 19734 rows . . imported "TESTUSER3"."TABLE2" 615.2 KB 4291 rows . . imported "TESTUSER4"."DRP" 429.5 KB 1521 rows . . imported "TESTUSER4"."ROLES" 401.0 KB 1521 rows . . imported "TESTUSER3"."DEPARTMENT" 5.554 KB 2 rows . . imported "TESTUSER3"."PROJECT" 5.554 KB 2 rows . . imported "TESTUSER3"."TABLE1" 10.39 KB 3 rows . . imported "TESTUSER3"."TABLE_12" 5.593 KB 6 rows . . imported "TESTUSER3"."TEST13OCT20" 11.60 KB 10 rows . . imported "TESTUSER4"."TABLE_11" 5.593 KB 6 rows . . imported "TESTUSER4"."TABLE_TEST" 5.812 KB 24 rows . . imported "TESTUSER4"."TEST15OCT20" 11.60 KB 10 rows . . imported "TESTUSER4"."TEST16OCT20" 15.67 KB 22 rows . . imported "TESTUSER4"."USERS" 11.35 KB 99 rows . . imported "TESTUSER3"."ROLES" 0 KB 0 rows Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS Processing object type DATABASE_EXPORT/STATISTICS/MARKER Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA Processing object type DATABASE_EXPORT/SCHEMA/PASSWORD_HISTORY ORA-39111: Dependent object type PASSWORD_HISTORY:"TESTUSER1" skipped, base object type USER:"TESTUSER1" already exists Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER Job "SYS"."SYS_IMPORT_FULL_01" completed with 33 error(s) at Sat Jan 23 17:21:44 2021 elapsed 0 00:00:46