Because Remedy drops then creates views (instead of using Create or Replace) when modifying a form, Join form views will sometimes show as Invalid. When you try to access data from those views Oracle will automatically compile them (at least it always has for me). Since I use TOAD to access my Oacle DB I use the menu item of Recompile all invalid objects to clean up these. An Invalid view can mean that something as simple as a View or Table that the join is based on has changed. The change may not have affected the view data. Robert's select top 1 * from <view> should work or so should select * from <view> where rownum <= 1 Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Robert Molenda Sent: Tuesday, February 12, 2008 9:35 AM To: arslist@ARSLIST.ORG Subject: Re: Can ARSystem database - invalid views be deleted? ** Maybe - maybe Not! First, does the form still exist in ARS? (CFG_SERVICE_CATALOG_LOOKUP for example), if so, open the form in admin tool, ensure there are no "error messages" coming up, and 're-save' the form. This will drop (yes drop) and Rebuild the view. Then it should be OK. If you attempt to 'select top 1 * from <view>' what type of error does Oracle vice back? HTH Robert Molenda On Feb 11, 2008 10:40 PM, Prashant Patil <[EMAIL PROTECTED]> wrote: ** 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"