我这边环境是WINDOWS2003+ORACLE9.2.0.1.0,想用BAT实现自动恢复备数据库,我有脚本如下,大意是用SYS删除TEST用户,然后新建TEST用户,再执行脚本;为什么我用以下脚本执行时窗口一直停留在sqlplus -s /nolog这个界面上,而不往下执行呢?
sqlplus -s /nolog
spool /sql.log
conn / as sysdba
WHENEVER SQLERROR continue;
WHENEVER OSERROR EXIT 1
select * from dual;
drop user test cascade;
CREATE USER "test" PROFILE "DEFAULT" IDENTIFIED BY "test" DEFAULT TABLESPACE "TEST" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT SYSDBA TO "test" WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO "test" WITH ADMIN OPTION;
GRANT "CONNECT" TO "test" WITH ADMIN OPTION;
GRANT "DBA" TO "test" WITH ADMIN OPTION;
GRANT "EXP_FULL_DATABASE" TO "test" WITH ADMIN OPTION;
GRANT "IMP_FULL_DATABASE" TO "test" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "test" WITH ADMIN OPTION;
conn test/test
WHENEVER SQLERROR continue;
WHENEVER OSERROR EXIT 1
select * from dual;
@ /sript.sql;
@ /job.sql;
spool off
EXIT 0
sqlplus -s /nolog
spool /sql.log
conn / as sysdba
WHENEVER SQLERROR continue;
WHENEVER OSERROR EXIT 1
select * from dual;
drop user test cascade;
CREATE USER "test" PROFILE "DEFAULT" IDENTIFIED BY "test" DEFAULT TABLESPACE "TEST" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT SYSDBA TO "test" WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO "test" WITH ADMIN OPTION;
GRANT "CONNECT" TO "test" WITH ADMIN OPTION;
GRANT "DBA" TO "test" WITH ADMIN OPTION;
GRANT "EXP_FULL_DATABASE" TO "test" WITH ADMIN OPTION;
GRANT "IMP_FULL_DATABASE" TO "test" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "test" WITH ADMIN OPTION;
conn test/test
WHENEVER SQLERROR continue;
WHENEVER OSERROR EXIT 1
select * from dual;
@ /sript.sql;
@ /job.sql;
spool off
EXIT 0
解决方案 »
- ORACLE表主键自增长问题
- dao.executeQuery() 执行第一次没问题 第2次就报数据类型转换异常
- 我装的oracel 9i数据库在启动企业管里面数据库无法启动?
- 请大家帮写 日期+流水号的存储过程 ,多用户使用绝不能重复
- 关于sqlplus的问题
- 有一些小问题~ :)
- createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT)第三个参数
- ora-0091 无效字符错误求解
- 帮忙解释以下的sql:::
- 数据库设计问题:是使用一个超大表还是使用多个小表?
- 各位大哥大姐好,求救BAT实现自动恢复的脚本.
- 关于DDL操作会自动提交事务的问题!!!
所以要把下面的sql命令写在一个sql文件中
先将要执行的SQL语句写一个sql脚本文件.例如: star.sql
BAT文件中加入一句 sqlplus system/admin @star.sql 即可可是执行时报SP2-0310:无法打开文件,不知道是何原因.