Hi All, Solaris 5.10 Oracle 10.2 ARSystem 7.1 ServiceDesk 7
In the ARSystem database I can see some 100 views with status "INVALID". The "Created" and "Last_ddl_time" have exactly the same date/time. Is it ok to delete these invalid views? Is it possible that some remedy workflow has not been activated and later may be required? There is an audit being carried out and we have been informed that invalid views should not exist in the db! Please advise. Example entries are: OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL_TIME STATUS ARADMIN CFG_SERVICE_CATALOG_LOOKUP VIEW 01/10/2008 14:26:20 01/10/2008 14:26:20 INVALID ARADMIN B672 VIEW 01/10/2008 14:26:20 01/10/2008 14:26:20 INVALID ARADMIN BMC_CORE_BMC_RACK VIEW 11/29/2007 10:16:20 11/29/2007 10:16:20 INVALID Thanks, Prashant _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"