DBA*Robot intelligent error handling
C:\Project\DbaRobot\demo>dbarobot -rvo prod demoplay
Opening demoplay.sql
============================================================================
alter schema demo1
============================================================================
connect to demo1@prod
alter table t1 drop column (f2) .. ignored
alter table t1 add (f3 integer) .. ok
alter table t1 add (f4 integer) .. ok
begin pkg1.p1; end; .. ok
begin pkg1.p1; end; .. ok
Closing demoplay.sql
Recompiling invalid objects ..
Done.
C:\Project\DbaRobot\demo>dbarobot -rvo prod demoplay
Opening demoplay.sql
============================================================================
alter schema demo1
============================================================================
connect to demo1@prod
alter table t1 drop column (f2) .. ignored
alter table t1 add (f3 integer) .. ignored
alter table t1 add (f4 integer) .. ignored
begin pkg1.p1; end; .. ok
begin pkg1.p1; end; .. ok
Closing demoplay.sql
Recompiling invalid objects ..
Done.
C:\Project\DbaRobot\demo>dbarobot -rvo prod demodrop
Opening demodrop.sql
============================================================================
drop schema demo1
============================================================================
connect to dbarobot@prod
create user demo1 identified by values 'DD9FD1922A0AFC29' .. ignored
grant create session to demo1 .. ok
connect to demo1@prod
drop package pkg1 .. ok
drop table t1 .. ok
connect to dbarobot@prod
drop user demo1 .. ok
Closing demodrop.sql
Recompiling invalid objects ..
Done.
C:\Project\DbaRobot\demo>dbarobot -rvo prod demoplay
Opening demoplay.sql
============================================================================
alter schema demo1
============================================================================
Error: ORA-01918: Benutzer 'DEMO1' ist nicht vorhanden
in demoplay.sql, at line 5
|
|
SQL*Plus behaviour
C:\Project\DbaRobot\demo>sqlplus dbarobot@prod
SQL*Plus: Release 9.0.1.0.1 - Production on Wed Sep 28 10:41:22 2005
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Release 9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
SQL> @demoplay
============================================================================
alter schema demo1
============================================================================
Enter value for demo1_pwd: demo1
Enter value for ora_sid: prod
Connected.
alter table t1 drop column (f2)
*
ERROR at line 1:
ORA-00904: invalid column name
Table altered.
Table altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
SQL> @demoplay
============================================================================
alter schema demo1
============================================================================
Connected.
alter table t1 drop column (f2)
*
ERROR at line 1:
ORA-00904: invalid column name
alter table t1 add (f3 integer)
*
ERROR at line 1:
ORA-01430: column being added already exists in table
alter table t1 add (f4 integer)
*
ERROR at line 1:
ORA-01430: column being added already exists in table
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
SQL> @demodrop
============================================================================
drop schema demo1
============================================================================
Enter value for dbarobot_pwd: dbapwd
Connected.
create user demo1 identified by values 'DD9FD1922A0AFC29'
*
ERROR at line 1:
ORA-01920: user name 'DEMO1' conflicts with another user or role name
Grant succeeded.
Connected.
Package dropped.
Table dropped.
Connected.
User dropped.
SQL> @demoplay
============================================================================
alter schema demo1
============================================================================
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL>
|
