1、如果你不需要logon到server3,那在a.bat中不需要用到user3/pss3,可以用/nologin参数指定不登陆模式
sqlplus.exe /nologin @c:\b.sql
2、可以使用whenever sqlerror命令来控制,在b.sql首部加上
WHENEVER SQLERROR EXIT 101 ROLLBACK
sqlplus.exe /nologin @c:\b.sql
2、可以使用whenever sqlerror命令来控制,在b.sql首部加上
WHENEVER SQLERROR EXIT 101 ROLLBACK
解决方案 »
- 求个安字段统计查询的sql语句,有分
- 关于数据库复制的问题
- 可否使用觸發器剔除批量插入的數據中的重複主鍵數據而不引發異常
- 关于oracle10g Personal Edition下载问题
- oracle9i与oracle10g 区别
- 在Oracle里怎么实现SQL Server的左连接、右连接和全连接?
- 莫名奇妙的问题?
- Windows下怎么访问ORACLE 最快,ADO? ODBC? ProC??
- 从远程数据库取得数据,然后在本地用这些数据建立一个表,插入数据,应该怎么做?
- 如何将大容量数据分片处理和保存?
- 怎样通过SQL语句设定对一个表的只读、读写权限???
- 请问在Oracle中怎么实现SqlServer中的自增?
从server1向server2上复制数据
采用过程
connect server2 -> delete server2相关数据-> copy server1的数据->..我想在delete 之前看看server1的连接状况,如果连不上(虽然可能性很小),就不执行复制
还能用WHENEVER SQLERROR EXIT 101 ROLLBACK 吗?
The WHENEVER SQLERROR command is triggered by SQL command or PL/SQL block errors, and not by SQL*Plus command errors. Examples
The commands in the following command file cause SQL*Plus to exit and return the SQL error code if the SQL UPDATE command fails: SQL> WHENEVER SQLERROR EXIT SQL.SQLCODE
SQL> UPDATE EMP SET SAL = SAL*1.1
The following SQL command error causes SQL*Plus to exit and return the SQL error code: SQL> WHENEVER SQLERROR EXIT SQL.SQLCODE
SQL> select column_does_not_exiSt from dual;
select column_does_not_exiSt from dual
*
ERROR at line 1:
ORA-00904: invalid column nameDisconnected from Oracle.....
The following SQL command error causes SQL*Plus to exit and return the value of the variable my_error_var: SQL> define my_error_var = 99
SQL> WHENEVER SQLERROR EXIT my_error_var
SQL> UPDATE non_existed_table set col1 = col1 + 1;UPDATE NON_EXISTED_TABLE set col1 = col1 + 1
*
ERROR at line 1:
ORA-00942: table or view does not existDisconnected from Oracle.....
The following examples show that the WHENEVER SQLERROR command does not have any effect on SQL*Plus commands, but does on SQL commands and PL/SQL blocks: SQL> WHENEVER SQLERROR EXIT SQL.SQLCODE
SQL> column ename headIing "Employee Name"Unknown COLUMN option "headiing"SQL> show non_existed_optionUnknown SHOW option "non_existed_option"
SQL> get non_existed_file.sql
Unable to open "non_existed_file.sql"
The following PL/SQL block error causes SQL*Plus to exit and return the SQL error code: SQL> WHENEVER SQLERROR EXIT SQL.SQLCODE
SQL> begin
2 select column_does_not_exiSt from dual;
3 end;
4 /select column_does_not_exiSt from dual;
*
ERROR at line 2:
ORA-06550: line 2, column 10:
PLS-00201: identifier 'COLUMN_DOES_NOT_EXIST' must be declared
ORA-06550: line 2, column 3:
PL/SQL: SQL Statement ignoredDisconnected from Oracle.....
如果加上101 ROLLBACK和
SQL.SQLCODE有什么用
101 ROLLBACK有问题
会出现资源耗尽的错误。。
加上SQL.SQLCODE 或者不加,没有问题,和预料一样