Imp .dmp file and ORA-00040
IMP-00041: Warning: create object has a compile warning "CREATE FORCE VIEW
"ECA"."MVIEW_WORKLOAD" ("WORK"
"LOADID","IMPORT_TIME","QUERYID","APPLICATION","CARDINALITY","RESULTSIZE","L"
"ASTUSE","FREQUENCY","OWNER","PRIORITY","QUERY","RESPONSETIME") AS "
"select"
" a.collectionid# as workloadid,"
" a.collecttime as import_time,"
" a.queryid# as queryid,"
" a.application,"
" a.cardinality,"
" a.resultsize,"
" a.qdate as lastuse,"
" a.frequency,"
" a.uname as owner,"
" a.priority,"
" a.sql_text as query,"
" a.exec_time as responsetime"
"from SYSTEM.MVIEW$_ADV_WORKLOAD A, SYSTEM.MVIEW$_ADV_LOG B, ALL_USERS D"
"WHERE a.collectionid# = b.runid#"
"AND b.uname = d.username"
"AND d.user_id = userenv('SCHEMAID')"
When i import a dump file to Oracle 11g,and log file have this information.
My import statement:
imp userid='ECA/CCIR@ORCL'
file='E:\Bak\ECAOracleBak\ecasys20130513empty\ecasys20130513empty.dmp'
log='D:\app\Administrator\oradata\orcl\ECASYS.log' full=y ignore=y;
Please help me!
No comments:
Post a Comment