是新创建的表空间和用户 CREATE TABLESPACE "xxxx" LOGGING DATAFILE 'xxxx.ora' SIZE 5M EXTENT AUTOEXTEND ON MAXSIZE UNLIMITED MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO CREATE USER "xxxx" PROFILE "DEFAULT" IDENTIFIED BY "123" DEFAULT TABLESPACE "xxxx" ACCOUNT UNLOCK; GRANT "CONNECT" TO "xxxx"; GRANT "DBA" TO "xxxx"; GRANT "RESOURCE" TO "xxxx"; grant unlimited tablespace to "xxxx"; 导出语句 exp xxxx/123@yyyy file=x:\xxxx.dmp log=x:\exp_xxxx.log owner=xxxx 导出没有错误和警告导入语句 imp "'sys/sys@zzzz as sysdba'" file=x:\xxxx.dmp log=x:\imp_xxxx.log fromuser=xxxx touser=xxxx 导入时产生上面的错误信息另外,数据库版本是 9.2.0.6.0 操作系统是Win2k+sp4
CREATE TABLESPACE "xxxx"
LOGGING
DATAFILE 'xxxx.ora' SIZE 5M EXTENT AUTOEXTEND ON MAXSIZE UNLIMITED
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO CREATE USER "xxxx" PROFILE "DEFAULT"
IDENTIFIED BY "123" DEFAULT TABLESPACE "xxxx"
ACCOUNT UNLOCK;
GRANT "CONNECT" TO "xxxx";
GRANT "DBA" TO "xxxx";
GRANT "RESOURCE" TO "xxxx";
grant unlimited tablespace to "xxxx";
导出语句
exp xxxx/123@yyyy file=x:\xxxx.dmp log=x:\exp_xxxx.log owner=xxxx
导出没有错误和警告导入语句
imp "'sys/sys@zzzz as sysdba'" file=x:\xxxx.dmp log=x:\imp_xxxx.log fromuser=xxxx touser=xxxx
导入时产生上面的错误信息另外,数据库版本是 9.2.0.6.0 操作系统是Win2k+sp4
imp sys/sys@zzzz file=... rows=N,fromuser=xxx,touser=....再導入數據,
imp sys/sys@zzzz file=... ignore=Y,fromuser=xxx,touser=....