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命令；

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26129555/viewspace-1606726/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26129555/viewspace-1606726/