DBA*Robot Logfile Demo
No output
C:\Project\DbaRobot\demo>dbarobot -ro prod demoplay
Verbose output
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.
Verbose output with timestamps
C:\Project\DbaRobot\demo>dbarobot -rvto prod demoplay
2005.09.28 10:06:27: Opening demoplay.sql
2005.09.28 10:06:27: ============================================================================
2005.09.28 10:06:27: alter schema demo1
2005.09.28 10:06:27: ============================================================================
2005.09.28 10:06:27: connect to demo1@prod
2005.09.28 10:06:27: alter table t1 drop column (f2) .. ignored
2005.09.28 10:06:27: alter table t1 add (f3 integer) .. ignored
2005.09.28 10:06:27: alter table t1 add (f4 integer) .. ignored
2005.09.28 10:06:27: begin pkg1.p1; end; .. ok
2005.09.28 10:06:27: begin pkg1.p1; end; .. ok
2005.09.28 10:06:27: Closing demoplay.sql
2005.09.28 10:06:27: Recompiling invalid objects ..
2005.09.28 10:06:27: Done.
Debugging
C:\Project\DbaRobot\demo>dbarobot -rdo prod demoplay
com.oekosoft.framework.util.PropertyManager reading property file c:\project\dbarobot/dbarobot.properties
com.oekosoft.framework.persistence.db.DbConnectionProducerProxy connect to dbarobot@prod
com.oekosoft.application.dbarobot.SqlScriptParser Opening demoplay.sql
com.oekosoft.application.dbarobot.SqlScriptParser =============================================================
com.oekosoft.application.dbarobot.SqlScriptParser alter schema demo1
com.oekosoft.application.dbarobot.SqlScriptParser =============================================================
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
alter user demo1 grant connect through dbarobot
com.oekosoft.application.dbarobot.SqlScriptParser connect to demo1
com.oekosoft.framework.persistence.db.DbConnectionProducerProxy connect to demo1@&&ora_sid
com.oekosoft.framework.persistence.db.DbConnectionProducerProxy proxyConnection of type oracle.jdbc.driver.Or
com.oekosoft.application.dbarobot.SqlScriptParser @prod
com.oekosoft.application.dbarobot.SqlScriptParser alter table t1 drop column (f2)
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
alter table t1 drop column (f2)
com.oekosoft.application.dbarobot.DbExceptionHandler drop 02289
com.oekosoft.application.dbarobot.DbExceptionHandler drop 01919
com.oekosoft.application.dbarobot.DbExceptionHandler revoke 00942
com.oekosoft.application.dbarobot.DbExceptionHandler drop 01918
com.oekosoft.application.dbarobot.DbExceptionHandler revoke 01927
com.oekosoft.application.dbarobot.DbExceptionHandler alter 02264
com.oekosoft.application.dbarobot.DbExceptionHandler alter 01442
com.oekosoft.application.dbarobot.DbExceptionHandler alter 02261
com.oekosoft.application.dbarobot.DbExceptionHandler alter 02260
com.oekosoft.application.dbarobot.DbExceptionHandler revoke 01952
com.oekosoft.application.dbarobot.DbExceptionHandler drop 04080
com.oekosoft.application.dbarobot.DbExceptionHandler revoke 01951
com.oekosoft.application.dbarobot.DbExceptionHandler insert 00001
com.oekosoft.application.dbarobot.DbExceptionHandler drop 02024
com.oekosoft.application.dbarobot.DbExceptionHandler create 02379
com.oekosoft.application.dbarobot.DbExceptionHandler revoke 01919
com.oekosoft.application.dbarobot.DbExceptionHandler drop 04043
com.oekosoft.application.dbarobot.DbExceptionHandler alter 00904
com.oekosoft.application.dbarobot.DbExceptionHandler alter 01430
com.oekosoft.application.dbarobot.DbExceptionHandler create 00955
com.oekosoft.application.dbarobot.DbExceptionHandler alter 02443
com.oekosoft.application.dbarobot.DbExceptionHandler alter 02441
com.oekosoft.application.dbarobot.DbExceptionHandler drop 12003
com.oekosoft.application.dbarobot.DbExceptionHandler drop 01418
com.oekosoft.application.dbarobot.DbExceptionHandler create 12006
com.oekosoft.application.dbarobot.DbExceptionHandler create 02011
com.oekosoft.application.dbarobot.DbExceptionHandler revoke 04042
com.oekosoft.application.dbarobot.DbExceptionHandler drop 00942
com.oekosoft.application.dbarobot.DbExceptionHandler alter 02275
com.oekosoft.application.dbarobot.DbExceptionHandler alter 01451
com.oekosoft.application.dbarobot.DbExceptionHandler rename 955
com.oekosoft.application.dbarobot.DbExceptionHandler rename 4043
com.oekosoft.application.dbarobot.DbExceptionHandler create 01921
com.oekosoft.application.dbarobot.DbExceptionHandler create 01920
com.oekosoft.application.dbarobot.DbExceptionHandler messageCode: 00904
com.oekosoft.application.dbarobot.DbExceptionHandler ORA-00904: Ungnltiger Spaltenname (ignored)
com.oekosoft.application.dbarobot.SqlScriptParser .. ignored
com.oekosoft.application.dbarobot.SqlScriptParser .. ignored
com.oekosoft.application.dbarobot.SqlScriptParser alter table t1 add (f3 integer)
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
alter table t1 add (f3 integer)
com.oekosoft.application.dbarobot.DbExceptionHandler messageCode: 01430
com.oekosoft.application.dbarobot.DbExceptionHandler ORA-01430: Angefngte Spalte bereits in Tabelle vorhanden (ignored)
com.oekosoft.application.dbarobot.SqlScriptParser .. ignored
com.oekosoft.application.dbarobot.SqlScriptParser alter table t1 add (f4 integer)
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
alter table t1 add (f4 integer)
com.oekosoft.application.dbarobot.DbExceptionHandler messageCode: 01430
com.oekosoft.application.dbarobot.DbExceptionHandler ORA-01430: Angefngte Spalte bereits in Tabelle vorhanden (ignored)
com.oekosoft.application.dbarobot.SqlScriptParser .. ignored
com.oekosoft.application.dbarobot.SqlScriptParser begin pkg1.p1; end;
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
begin pkg1.p1; end;
com.oekosoft.application.dbarobot.SqlScriptParser .. ok
com.oekosoft.application.dbarobot.SqlScriptParser begin pkg1.p1; end;
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
begin pkg1.p1; end;
com.oekosoft.application.dbarobot.SqlScriptParser .. ok
com.oekosoft.application.dbarobot.SqlScriptParser Closing demoplay.sql
com.oekosoft.application.dbarobot.Recompiler Recompiling invalid objects ..
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
select owner||'.'||object_name object,
object_type type,
object_id
from dba_objects a
where status = 'INVALID' and
object_type in ('PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'VIEW')
and owner not in ('SYS', 'SYSTEM')
order by object_type, object_name
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
select max(level) dlevel
from public_dependency
where level < 50
start with referenced_object_id=?
connect by object_id = prior referenced_object_id
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
select owner||'.'||object_name object,
object_type type,
object_id
from dba_objects a
where status = 'INVALID' and
object_type in ('PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'VIEW')
and owner not in ('SYS', 'SYSTEM')
order by object_type, object_name
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
select max(level) dlevel
from public_dependency
where level < 50
start with referenced_object_id=?
connect by object_id = prior referenced_object_id
com.oekosoft.framework.persistence.db.DbPreparedStatement
---
alter user demo1 revoke connect through dbarobot
java.lang.String Done.
|
Copyright ©
|
|
- generated by WPG 29.04.2007
|
