1、创建用户
create user test identified by test;
grant connect to test;grant resource to test;
2、导出数据dmp格式
exp LI/woshimima tables=test file=/u01/LI.dmp grants=y
3、导入dmp数据
imp system/manager fromuser=LI tables=(test)
1、创建用户
create user test identified by test;
grant connect to test;grant resource to test;
2、导出数据dmp格式
exp LI/woshimima tables=test file=/u01/LI.dmp grants=y
3、导入dmp数据
imp system/manager fromuser=LI tables=(test)