Hi Rafa, Great, sure we'll add this check to the consistency test. We'll let you know in this list when it's implemented.
Thank you, Juan Pablo On 15:15 Tue 18 Aug , Rafa Roda @ Openbravo wrote: > 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 ------------------------------------------------------------------------------ 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
