imp 全量导出，按用户导入

之前一直用惯了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！