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 > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
