oracle自动imp脚本

先删除用户，在重建用户，然后赋权，

脚本放到crontab中定时执行即可

source /opt/.bash_profile

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

sqlplus /nolog <<EOF

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 VIEW          TO 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 INDEX      TO JLTGAME;

GRANT ALTER ANY TABLE      TO JLTGAME;

GRANT CREATE ANY TYPE      TO JLTGAME;

GRANT CREATE ANY VIEW      TO JLTGAME;

GRANT CREATE SEQUENCE      TO JLTGAME;

GRANT CREATE SNAPSHOT      TO 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 TRIGGER    TO JLTGAME;

GRANT CREATE ANY TRIGGER   TO JLTGAME;

GRANT ALTER ANY INDEXTYPE  TO 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

• ·Useful SQL reference
• ·linux下安装oracle 8.17
• ·恢复备份查询手册
• ·[基础]9i新特性之五闪回查询
• ·ResultSetsfromStoredPro
• ·对Foreign Key的进一步认识。
• ·XML 与 XML DB 和 ODP.NET
• ·我没装Oracle,下面的连接代码无法测试.如
• ·下载Oracle数据库中的Blob二进制文件，
• ·oracle数据库中关于null排序的问题