i had take a structure backup on database. expdp works perfect. but while impdp i am getting error in mview to get ddl of Mview.
expdp :-
expdp abc/xyz full=Y CONTENT=METADATA_ONLY directory=di1 dumpfile=structure_backup.dmp logfile=structure_backup.log KEEP_MASTER=Y
impdp :-
impdp abc DIRECTORY=di1 DUMPFILE= structure_backup.dmp LOGFILE= structure_backup_imp_mv.LOG SQLFILE=MATERIALIZED_VIEW_DDL.SQL INCLUDE=MATERIALIZED_VIEW
i am getting error :-
Import: Release 12.2.0.1.0 - Production on Thu Nov 22 12:23:30 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
Master table "abc"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "abc"."SYS_SQL_FILE_FULL_01": abc/******** DIRECTORY=DIR1 DUMPFILE=structure_backup.dmp LOGFILE=structure_backup_imp_mv.LOG SQLFILE=MATERIALIZED_VIEW_DDL.SQL INCLUDE=MATERIALIZED_VIEW
Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [MATERIALIZED_VIEW:"user1"."mview1"]
ORA-06502: PL/SQL: numeric or value error
LPX-00216: invalid character 0 (0x0)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12092
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 25027
ORA-06512: at "SYS.UTL_XML", line 384
ORA-06512: at "SYS.DBMS_METADATA_INT", line 12552
ORA-06512: at "SYS.DBMS_METADATA_INT", line 12698
ORA-06512: at "SYS.DBMS_METADATA", line 5862
ORA-06512: at "SYS.DBMS_METADATA", line 11684
ORA-06512: at "SYS.KUPW$WORKER", line 24529
----- PL/SQL Call Stack -----
object line object
handle number name
0xdb29d438 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0xdb29d438 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0xdb29d438 25091 package body SYS.KUPW$WORKER.PUT_DDLS
0xdb29d438 5084 package body SYS.KUPW$WORKER.LOAD_METADATA
0xdb29d438 6134 package body SYS.KUPW$WORKER.SQL_FILE_JOB
0xdb29d438 13164 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0xdb29d438 2311 package body SYS.KUPW$WORKER.MAIN
0x106b1ab98 2 anonymous block
l_valid: -3 - Not Loading INDEX_BY_NAME with type CONSTRAINT
l_valid : 1 - Loading COLLATION_CLAUSE with type NULL
l_valid: -3 - Not Loading SEGMENT_CREATION with type TABLE
l_valid: -3 - Not Loading TEN_G_LOGON_ALLOWED with type USER
l_valid: -3 - Not Loading DBA with type JOB
l_valid : 1 - Loading SOURCE_VERSION with type NULL
Job "abc"."SYS_SQL_FILE_FULL_01" stopped due to fatal error at Thu Nov 22 12:23:48 2018 elapsed 0 00:00:12