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博客

Linux上exp owner参数的测试

最新文章