oracle 9i数据库,exp导出的时候,带了full=y参数,导出dmp文件;然后另外一个空的数据库(同样的oracle 9i版本,dbca工具建立数据库后,没有新建表空间和用户)上,用imp system/system@test full=y导入,导入日志中出现很多错误,类似信息如下:
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE UNDO TABLESPACE "UNDOTBS1" BLOCKSIZE 8192 DATAFILE 'E:ORACLEORADA"
"TATESTUNDOTBS01.DBF' SIZE 356515840 AUTOEXTEND ON NEXT 5242880 MAX"
"SIZE 32767M EXTENT MANAGEMENT LOCAL "
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE USER "OUTLN" IDENTIFIED BY VALUES '4A3BA55E08595C81' TEMPORARY TABLE"
"SPACE "TEMP" PASSWORD EXPIRE ACCOUNT LOCK"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE ROLE "SELECT_CATALOG_ROLE""
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE SEQUENCE "MVIEW$_ADVSEQ_GENERIC" MINVALUE 1 MAXVALUE 4294967295 INCR"
"EMENT BY 1 START WITH 1 CACHE 50 NOORDER NOCYCLE"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE PUBLIC SYNONYM "SQLINVALIDINDEXSPECIFICATIONEX" FOR "SYS"."SQLINVALI"
"DINDEXSPECIFICATIONEX""
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "WM$LOCK_TABLE_TYPE" TIMESTAMP '2008-05-15:21:54:15' OID '8A3DB"
"78598C35DE2E034080020EDC61B' "
" as"
" table of wmsys.wm$lock_info_type;"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE FORCE VIEW "OLAPSYS"."DBA$OLAP2_FACTTBLFCTMAPS" "
" ("OWNER","CUBE_NAME","MEASURE_NAME","DIM_HIER_COMBO_ID","FACT_TABLE_OWN"
"ER","FACT_TABLE_NAME","COLUMN_NAME","DATA_TYPE") AS "
"select cmm.owner owner,"
" cmm.cube_name cube_name,"
" cmm.measure_name measure_name,"
" cmm.dim_hier_combo_id dim_hier_combo_id,"
" cmm.fact_table_owner fact_table_owner,"
" cmm.fact_table_name fact_table_name,"
" cmm.column_name column_name,"
" (case when c.data_type = 'NUMBER' then 0"
" when c.data_type = 'DATE' then 7"
" else 1 end)"
" data_type"
"from olapsys.dba$olap2_cube_measure_maps cmm,"
" dba_olap_columns c"
"where"
" cmm.fact_table_owner = c.owner"
" and cmm.fact_table_name = c.table_name"
" and cmm.column_name = c.column_name"
现在有以下疑问:
1、全库导入的dmp文件,用imp全库导入是不是在空库的环境下导入?
2、出现以上信息是否意味着导入不完整?
3、如果这样导入是完全的,那如何设置才能让日志中不出现这些错误信息?
谢谢各位~