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‘