impdp ...problem while importing Mview
709382Jul 21 2009 — edited Jul 21 2009Hi
i am facing some strange problem in expdp/impdp.
if i use EXPDP/IMPDP for entire schema,results are fine.
But if i customize my parfile as follows
DUMPFILE=selective_exp_MV2.dmp
logfile=selective_exp_MV2.log
DIRECTORY=export_dumps
include=table:"in ('TABLE_STATS_TEST','AUDIT_TABLE','T_APPLICATION_BKP','TEMP_LOGOFF_TABLE','TEMP_LOGON_TABLE','T_AUDIT','T_SYSTEM_USERS','TAB1','TAB2','TAB3')"
QUERY = TAB1:"where n=10"
QUERY = TAB2:"where n=20"
QUERY = TAB3:"where n=20"
include=procdure,trigger,materialized_view
i am getting the following error while importing the above exp dump into another user schema.
ORA-39083: Object type MATERIALIZED_VIEW failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
CREATE MATERIALIZED VIEW "AUDITTEST"."MVIEW1" USING ("MVIEW1", (8, 'LD3ORA1', 1, 0, 0, "AUDITTEST", "TAB1", '2009-07-21 11:57:07', 0, 0, '2009-07-21 11:57:07', '', 0, 7504968, 0, NULL), 2097472, 8, ('2009-07-21 11:57:07', 1, 0, 0, 7504968, 0, 0, 2, NULL, NULL)) REFRESH COMPLETE AS select * from tab1
Job "DBAOPER"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 14:12:15
It is working fine if i use schema import .I am able to create the materialized views from SQl prompt also.
What must be the reason
thanks,
Pramod