A库:
通过sysdba用户exp导出的数据备份
B库:
全新oracle数据库,没有原来的表空间和数据,需要导入A库备份文件,通过imp(dba用户)导入导了几次都没成功,现在似乎B库有A库的表空间和用户了,接下来该怎么做?
通过sysdba用户exp导出的数据备份
B库:
全新oracle数据库,没有原来的表空间和数据,需要导入A库备份文件,通过imp(dba用户)导入导了几次都没成功,现在似乎B库有A库的表空间和用户了,接下来该怎么做?
A表 字段如下:
cname,
ctype
B表字段如下 :
tname,
cname,
ctype
问题:能否使用子查询将A插入B,同时给 tname附上固定值
"CREATE PUBLIC SYNONYM "SQLDEFINITIONSEQUENCE" FOR "SYS"."SQLDEFINITIONSEQUE"
"NCE""
IMP-00015: following statement failed because the object already exists:
"CREATE PUBLIC SYNONYM "GENEXTRASTRUCT" FOR "SYS"."GENEXTRASTRUCT""
IMP-00015: following statement failed because the object already exists:
"CREATE PUBLIC SYNONYM "OLAPI_MDX_ROWSET_IMPL_T" FOR "SYS"."OLAPI_MDX_ROWSET"
"_IMPL_T""
IMP-00015: following statement failed because the object already exists:
"CREATE TYPE "ODCIOBJECT" TIMESTAMP '2004-03-10:00:02:20' OID '3BAEF8A3DBFA4"
"3D58C23BA86688781C3' AS object"
"("
" ObjectSchema VARCHAR2(30),"
" ObjectName VARCHAR2(30)"
");"
IMP-00015: following statement failed because the object already exists:
"CREATE TYPE "ODCIOBJECTLIST" TIMESTAMP '2004-03-10:00:02:20' OID '99FF7135F"
"9DF444F9C24C788E6F40396' AS VARRAY(32) of ODCIObject;"
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"dbms_resource_manager.create_consumer_group('AUTO_TASK_CONSUMER_GROUP','Sys"
"tem maintenance task consumer group','ROUND-ROBIN');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE AUT
O_TASK_CONSUMER_GROUP. Remaining PL/SQL blocks for this object will be skipped.一导入就报这样的错误,屏幕翻滚的很快根本看不清,这是一部分错误
根据楼主的描述,应该是建立表对象等这种需要表空间的对象时,没有找到相应的表空间,导致导入失败。
exp逻辑导出会导出重建对象的sql,但是物理结构的内容不会帮你生成,你不需要自己手动建立所有的表空间。