DBA*Robot default behaviour
C:\Project\DbaRobot\demo>dbarobot -rvo prod demoplay
Opening demoplay.sql
============================================================================
alter schema demo1
============================================================================
connect to demo1@&&ora_sid
Error: ORA-01045: Benutzer DEMO1 hat keine CREATE SESSION-Berechtigung
DBA*Robot with -s option
C:\Project\DbaRobot\demo>dbarobot -rsvo 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.
|
|
SQL*Plus behaviour
C:\Project\DbaRobot\demo>sqlplus dbarobot@prod
SQL*Plus: Release 9.0.1.0.1 - Production on Wed Sep 28 10:52:34 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
ERROR:
ORA-01045: user DEMO1 lacks CREATE SESSION privilege; 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>
|
