oracle自动imp脚本代码

先删除用户，在重建用户，然后赋权，脚本放到crontab中定时执行即可

source /opt/.bash_profile

DATE=$(date +%Y%m%d)

sqlplus /nolog

connect / as sysdba;

DROP USER WAPUSER CASCADE;

DROP USER JLTGAME CASCADE;

CREATE USER "WAPUSER" PROFILE "DEFAULT"

IDENTIFIED BY "123456" DEFAULT TABLESPACE "JLTGAME"

TEMPORARY TABLESPACE "TEMP"

ACCOUNT UNLOCK;

CREATE USER "JLTGAME" PROFILE "DEFAULT"

IDENTIFIED BY "JLTGAME123" DEFAULT TABLESPACE "JLTGAME"

TEMPORARY TABLESPACE "TEMP"

ACCOUNT UNLOCK;

GRANT CREATE VIEWTO JLTGAME;

GRANT CREATE TABLE TO JLTGAME;

GRANT ALTER ANY TYPE TO JLTGAME;

GRANT CREATE SESSION TO JLTGAME;

GRANT CREATE SYNONYM TO JLTGAME;

GRANT CREATE TRIGGER TO JLTGAME;

GRANT ALTER ANY INDEXTO JLTGAME;

GRANT ALTER ANY TABLETO JLTGAME;

GRANT CREATE ANY TYPETO JLTGAME;

GRANT CREATE ANY VIEWTO JLTGAME;

GRANT CREATE SEQUENCETO JLTGAME;

GRANT CREATE SNAPSHOTTO JLTGAME;

GRANT ALTER TABLESPACE TO JLTGAME;

GRANT CREATE ANY INDEX TO JLTGAME;

GRANT CREATE ANY TABLE TO JLTGAME;

GRANT CREATE PROCEDURE TO JLTGAME;

GRANT ALTER ANY TRIGGERTO JLTGAME;

GRANT CREATE ANY TRIGGER TO JLTGAME;

GRANT ALTER ANY INDEXTYPETO JLTGAME;

GRANT CREATE ANY INDEXTYPE TO JLTGAME;

GRANT UNLIMITED TABLESPACE TO JLTGAME;

exit

EOF

imp userid=jltgame/JLTGAME123 file=/backup/52backup/jltgame$DATE.dmp full=y log=/opt/logjltgame$DATE.dmp

• ·教你用Linux完成Oracle自动物理备份
• ·如何移动表达到减小数据文件大小的目的
• ·数据块转储及RDBA的转换
• ·Oracle数据库的管理
• ·Oracle10gR2 ORA-19554的S
• ·启动/关闭数据库归档(ARCHIVELOG)模
• ·Oracle10gR2简单测试Rman的功能
• ·解读Oracle 9201的控制文件（一）
• ·如何使用BBED修复损坏的BLOCK
• ·解读Oracle 9201的控制文件 （二）