Dear release management team,
I had a look at the database consistency check [1] [2] I was was wondering
if you could add a check to validate the status of the database objects
(procedures, ...).
For this, the following select should give zero (replace the owner by the
corresponding one):
SELECT COUNT(*)
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
AND OWNER = 'TAD_240'
If this query is giving you a count > 0, display the database objects in an
invalid state with (replace the owner by the corresponding one):
SELECT OBJECT_TYPE, OBJECT_NAME, STATUS
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
AND OWNER = 'TAD_240'
ORDER BY OBJECT_TYPE, OBJECT_NAME
Regards,
Rafa Roda @ Openbravo
[1] http://wiki.openbravo.com/wiki/Database_consistency_check
[2] http://wiki.openbravo.com/wiki/Database_Consistency_Test
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Openbravo-development mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-development
