Oracle数据库刷库步骤

以dba登录

sqlplus / as sysdba;

删除原有的同名用户

drop user XXX cascade;

创建新用户

create user XXX identified by pwd default tablespace XXX_DATA temporary tablespace XXX_DATA;

给用户授权

GRANT CONNECT,RESOURCE TO XXX;
GRANT CREATE ANY TABLE TO XXX;
GRANT CREATE ANY VIEW TO XXX;
GRANT CREATE ANY INDEX TO XXX;
GRANT CREATE ANY PROCEDURE TO XXX;
GRANT CREATE ANY SEQUENCE TO XXX;
GRANT CREATE DATABASE LINK TO XXX;
GRANT SELECT ANY DICTIONARY TO XXX;
GRANT IMP_FULL_DATABASE TO XXX;
GRANT READ,WRITE ON DIRECTORY XXX_ TO XXX;

导入数据

impdp xxx/pwd@xxdb directory=XXX_ dumpfile = xxxxxx.dmp schemas=xxx logfile=XXX.log full=y;

利用dba修改其他用户的密码

alter user 用户名 identified by 新密码;

重启数据库服务器

shutdown immediate;
startup;

数据文件的导出

expdp xxx/pwd@xxdb directory=XXX_ dumpfile = xxxxxx.dmp schemas=xxx logfile=XXX.log full=y;