;;; Import: Release 10.2.0.5.0 - 64bit Production on Saturday, 29 January, 2022 11:11:59 Copyright (c) 2003, 2007, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** schemas=NPSMIRTH_PRE directory=EXPORT_TMPDIR_DMD dumpfile=expdp_NPSMIRTH_PRE_28012022.dmp logfile=impdp_expdp_NPSMIRTH_PRE_28012022.log Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"NPSMIRTH_PRE" already exists Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "NPSMIRTH_PRE"."HIST_MESSAGES" 762.8 MB 259259 rows . . imported "NPSMIRTH_PRE"."MESSAGE" 63.75 KB 8 rows . . imported "NPSMIRTH_PRE"."CONFIGURATION" 380.9 MB 5206 rows . . imported "NPSMIRTH_PRE"."EVENT" 128.5 MB 95937 rows . . imported "NPSMIRTH_PRE"."AUDIT_MESSAGES_OUT" 17.81 MB 153880 rows . . imported "NPSMIRTH_PRE"."AUDIT_MESSAGES_IN" 10.31 MB 96411 rows . . imported "NPSMIRTH_PRE"."CHANNEL" 2.497 MB 22 rows . . imported "NPSMIRTH_PRE"."SCRIPT" 9.085 KB 4 rows . . imported "NPSMIRTH_PRE"."CODE_TEMPLATE" 8.945 KB 3 rows . . imported "NPSMIRTH_PRE"."ENCRYPTION_KEY" 5.320 KB 1 rows . . imported "NPSMIRTH_PRE"."CHANNEL_STATISTICS" 10.53 KB 41 rows . . imported "NPSMIRTH_PRE"."PERSON" 7.898 KB 2 rows . . imported "NPSMIRTH_PRE"."SCHEMA_INFO" 4.929 KB 1 rows . . imported "NPSMIRTH_PRE"."ALERT" 0 KB 0 rows . . imported "NPSMIRTH_PRE"."ALERT_EMAIL" 0 KB 0 rows . . imported "NPSMIRTH_PRE"."ATTACHMENT" 0 KB 0 rows . . imported "NPSMIRTH_PRE"."AUDIT_MESSAGES_IN_OLD" 0 KB 0 rows . . imported "NPSMIRTH_PRE"."CHANNEL_ALERT" 0 KB 0 rows . . imported "NPSMIRTH_PRE"."TEMPLATE" 0 KB 0 rows Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT ORA-39083: Object type OBJECT_GRANT failed to create with error: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself Failing sql is: GRANT SELECT ON "NPSMIRTH_PRE"."CHANNEL" TO "NPSMIRTH_PRE" Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 2 error(s) at 11:13:57