Linux上exp owner参数的测试

Linux上的测试:
--test1用户
create user test1 identified by test1;
grant connect,resource to test1;

--test2用户
create user test2 identified by test2;
grant connect,resource to test2;

--test3用户(会被锁定)
create user test3 identified by test3;
grant connect,resource to test3;

conn test1/test1
create table t (x int);
insert into t values (1);
commit;

conn test2/test2
create table t (x int);
insert into t values (1);
insert into t values (2);
commit;

conn test3/test3
create table t (x int);
insert into t values (1);
insert into t values (2);
commit;

exp system/oracle owner=test1,test2,test3 file=/home/oracle/sys_test123.dmp  log=/home/oracle/sys_test123.log

drop user test1 cascade;
drop user test2 cascade;
drop user test3 cascade;
create user test1 identified by test1;
grant connect,resource to test1;

create user test2 identified by test2;
grant connect,resource to test2;

create user test3 identified by test3;
grant connect,resource to test3;

alter user test3 account lock;

imp system/oracle full=y file=/home/oracle/sys_test123.dmp  log=/home/oracle/imp_sys_test123.log ignore=y  buffer=819200

结论:用户账号锁定不影响exp和imp命令;


请使用浏览器的分享功能分享到微信等