oracle导入dmp的时候提示某个表空间不存在,但这个表空间确实已经建立好了,是什么问题呢?
该dmp文件有多个表空间,我把这些表空间都给同一个用户XX配额了,XX也授权了dba,resource权限了,但imp的时候就是提示tablespace XXX dose not exist.操作代码如下:create tablespace CMS4iARTICLETABSPACE datafile 'CMS4iARTICLETABSPACE.dbf' size 300m autoextend on next 10m maxsize unlimited;create tablespace CMS4iTEMPLATETABSPACE datafile 'CMS4iTEMPLATETABSPACE.dbf' size 300m autoextend on next 10m maxsize unlimited;create tablespace CMS4iUSERTABSPACE datafile 'CMS4iUSERTABSPACE.dbf' size 300m autoextend on next 10m maxsize unlimited;create tablespace GZGOV datafile 'GZGOV.dbf' size 300m autoextend on next 10m maxsize unlimited;create tablespace impdata datafile 'impdata.dbf' size 300m autoextend on next 10m maxsize unlimited;create user Cadmin1 Identified By qazxsw default tablespace C4iARTICLETABSPACE;
create user Cadmin2 Identified By qazxsw default tablespace C4iTEMPLATETABSPACE;
create user Cadmin3 Identified By qazxsw default tablespace C4iUSERTABSPACE;
create user Cadmin4 Identified By qazxsw default tablespace GZGOV;
create user Cadmin5 Identified By qazxsw default tablespace impdata;grant dba,resource to Cadmin1;
grant dba,resource to Cadmin2;
grant dba,resource to Cadmin3;
grant dba,resource to Cadmin4;
grant dba,resource to Cadmin5;alter user Cadmin5 quota unlimited on C4iARTICLETABSPACE;
alter user Cadmin5 quota unlimited on C4iTEMPLATETABSPACE;
alter user Cadmin5 quota unlimited on C4iUSERTABSPACE;
alter user Cadmin5 quota unlimited on GZGOV;imp Cadmin5/qazxsw full=y file=c:\counter2013-01-15.dmp log=c:\130118_1.log运行时不断提示IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'C4iARTICLETABSPACE' does not existoracle
该dmp文件有多个表空间,我把这些表空间都给同一个用户XX配额了,XX也授权了dba,resource权限了,但imp的时候就是提示tablespace XXX dose not exist.操作代码如下:create tablespace CMS4iARTICLETABSPACE datafile 'CMS4iARTICLETABSPACE.dbf' size 300m autoextend on next 10m maxsize unlimited;create tablespace CMS4iTEMPLATETABSPACE datafile 'CMS4iTEMPLATETABSPACE.dbf' size 300m autoextend on next 10m maxsize unlimited;create tablespace CMS4iUSERTABSPACE datafile 'CMS4iUSERTABSPACE.dbf' size 300m autoextend on next 10m maxsize unlimited;create tablespace GZGOV datafile 'GZGOV.dbf' size 300m autoextend on next 10m maxsize unlimited;create tablespace impdata datafile 'impdata.dbf' size 300m autoextend on next 10m maxsize unlimited;create user Cadmin1 Identified By qazxsw default tablespace C4iARTICLETABSPACE;
create user Cadmin2 Identified By qazxsw default tablespace C4iTEMPLATETABSPACE;
create user Cadmin3 Identified By qazxsw default tablespace C4iUSERTABSPACE;
create user Cadmin4 Identified By qazxsw default tablespace GZGOV;
create user Cadmin5 Identified By qazxsw default tablespace impdata;grant dba,resource to Cadmin1;
grant dba,resource to Cadmin2;
grant dba,resource to Cadmin3;
grant dba,resource to Cadmin4;
grant dba,resource to Cadmin5;alter user Cadmin5 quota unlimited on C4iARTICLETABSPACE;
alter user Cadmin5 quota unlimited on C4iTEMPLATETABSPACE;
alter user Cadmin5 quota unlimited on C4iUSERTABSPACE;
alter user Cadmin5 quota unlimited on GZGOV;imp Cadmin5/qazxsw full=y file=c:\counter2013-01-15.dmp log=c:\130118_1.log运行时不断提示IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'C4iARTICLETABSPACE' does not existoracle
解决方案 »
- 想看一下Oracle日志文件到底都记录了什么内容,可是找不具体的位置啊
- 为什么我用system 测试Net服务配置一直都无法成功
- 请教一个sqlplus连接服务端的问题
- 请教数据库问题
- 怎样使用命令行修改oracle 数据库用户的密码 急急急。。。。
- oeder by性能问题
- 实现如此功能的sql怎么写,请高手不吝赐教
- 如何在非归档和归档备份模式之间进行切换
- 哪位有设计程序包,存储过程,触发器的资料?
- 一个老问题,sqlplus连接报错:协议适配器错误,请帮帮忙,谢谢!
- 求助一个关于全表扫描的问题
- Oracle 高级复制功能问题,在往复制组中添加主站点时,ORA-23375: 功能与数据库版本 SUNDAY.TEST.COM.CN 不兼
没看到你有create C4iARTICLETABSPACE表空间啊?