ORACLE用户创建&删除

●sqlplus登陆
sqlplus sys/isc@testgmmc as sysdba
●创建用户
create user testpoi3 IDENTIFIED by isc
account unlock;
grant dba,advisor to testpoi2;
●删除用户
drop user djcfw cascade;
●数据导出
exp testwms2/isc@test-193 OWNER=testwms2 FILE=D: emp estwms2.dmp
exp testapar/isc@hs OWNER=testapar FILE=D: estwms2.dmp TABLES=DEPT