1、创建表空间,并创建dba用户test,密码123456
create tablespace test_space
logging datafile 'd:\oracle_data\test_space.dbf'
size 500M autoextend on next 500M maxsize
unlimited extent management local segment space management auto;
create user test identified by 123456 default tablespace test_space;
grant dba to test;
grant unlimited tablespace to test;
grant select any table to test;
grant select any dictionary to test;
grant connect to test;
grant resource to test;
2、导入导出dmp命令
imp test/123456@orcl file=c:\test.dmp full=y ignore=y;
exp test/123456@orcl file=c:\test.dmp