Prashant, Is it possible that there there are missing fields in the underlying table that the view belongs to in their select statement?? Might be worth checking.. Where these created during the install of something? What was it?
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Prashant Patil Sent: Tuesday, February 12, 2008 1:41 AM To: arslist@ARSLIST.ORG Subject: Can ARSystem database - invalid views be deleted? ** 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 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.2/1272 - Release Date: 2/11/2008 5:28 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"