之前一直用惯了expdp,突然来了一个dmp文件,不上手啊,搞了1个小时;
1、删掉用户
drop user xxxx cascade;
2、重新创建用户
create user xxxx identified by xxxx default tablespace users;
grant unlimited tablespace to xxxx;
---需要创建job
grant create job to xxxx;
grant manage scheduler to xxxx;
3、导入dmp
imp system/oracle file=full.dmp fromuser=xxxx touser=xxxx ignore=yes log=a.log
之前的疑问在于这个dmp文件是全库的还是某一个用户的,总是报错!我也是醉了!
ORA-23327: imported deferred rpc data does not match string of importing db
Cause: Deferred rpc queues were imported from a database with a different global name or operating system than importing database.
Action: Deferred rpc data should only be imported into a database with the same global name and hardware and operating system.
Do not perform full import of a database containing deferred RPC data from another platform. This includes export/import between 32- and 64-bit platforms.
不建议如此做,还是基于用户做吧
主要是权限的问题:
因此,应该在导出时,确定权限
select * from dba_sys_privs where username='xxxx';
赋完权限后再imp!
1、删掉用户
drop user xxxx cascade;
2、重新创建用户
create user xxxx identified by xxxx default tablespace users;
grant unlimited tablespace to xxxx;
---需要创建job
grant create job to xxxx;
grant manage scheduler to xxxx;
3、导入dmp
imp system/oracle file=full.dmp fromuser=xxxx touser=xxxx ignore=yes log=a.log
之前的疑问在于这个dmp文件是全库的还是某一个用户的,总是报错!我也是醉了!
ORA-23327: imported deferred rpc data does not match string of importing db
Cause: Deferred rpc queues were imported from a database with a different global name or operating system than importing database.
Action: Deferred rpc data should only be imported into a database with the same global name and hardware and operating system.
Do not perform full import of a database containing deferred RPC data from another platform. This includes export/import between 32- and 64-bit platforms.
不建议如此做,还是基于用户做吧
主要是权限的问题:
因此,应该在导出时,确定权限
select * from dba_sys_privs where username='xxxx';
赋完权限后再imp!