创建用户
create user Irving identified by 123456;
创建表空间
CREATE TABLESPACE Irving datafile ‘E:\oracle\oradata\orcl\Irving.DBF‘ size 1500M autoextend on next 5M maxsize 3000M;
分配表空间
alter user Irving quota unlimited on Irving;
授权
grant connect,resource to Irving; grant create any sequence to Irving; grant create any table to Irving; grant delete any table to Irving; grant insert any table to Irving; grant select any table to Irving; grant unlimited tablespace to Irving; grant execute any procedure to Irving; grant update any table to Irving; grant create any view to Irving;
导入数据
imp system/123456 file=‘G:\checkdb_20210128.dmp‘ tablespaces=Irving fromuser=checkdb touser=Irving log=‘e:\a.txt‘
https://blog.csdn.net/lsyuan1989/article/details/50418665
https://blog.csdn.net/funnyfu0101/article/details/50219995
原文：https://www.cnblogs.com/shizhengwen/p/14674070.html