It turns out the database user aradmin had somehow lost the "crete view" privilege during migration from Oracle 9i to 10g. All is fine after our DBA added the privilege to aradmin. The breakthrough came when I turned on the SQL logging again and saved the form after changing name of an unused field. The log finally showed this:CREATE VIEW HPD_HelpDesk (Case_ID_,Submitted_By,...) AS SELECTT166.C1,C2,...17:28:00.9800 */*** ERROR *** ORA-01031: insufficient privileges Not sure why I couldn't locate similar error earlier. I plead temporary blindness. Thanks Jason, Joe for your responses. --- On Sun, 10/17/10, Jason Miller <[email protected]> wrote:
From: Jason Miller <[email protected]> Subject: Re: How to recreate missing view of a form? ARs 6.3, Oracle 10g To: [email protected] Date: Sunday, October 17, 2010, 5:31 PM ** Usually when I have seen an error about not being able to create a db view it was because there is a field with the name of a database keyword. I have seen this happen many times when somebody adds a field called 'function'. Jason On Oct 15, 2010 2:13 PM, "Rabi Tripathi" <[email protected]> wrote: > Hi all, for unknown reason the usual HPD_HELPDESK view for my HPD:Helpdesk > form is missing. I tried resaving the form, adding a data field and saving > etc to recreate the view, but no luck. On adding a field and saving, get the > usual error about sql view not being in place: > Field : Modified Time: > Creation of one of the SQL views for the form failed within the SQL database. > Operation completed successfully, but the SQL view is not in place. (ARERR > 69). > > Any ideas on recreating the view? I have some scripts reading directly from > this view, so it's a problem not to have this view. > > I though I could go to another server and do this > > select text from all_views where view_name = 'HPD_HELPDESK'; > > and use the resulting text to manually recreate this oracle view on this > server, but no luck so far. The "text" column is so long I am trouble having > all the text show up on sqlplus, no matter how I play with the display > settings. > > I though SQL log would show me the statement using which ARS is trying to > create the view, but can't locate it. > > What changed recently? Hmm a lot. Migrated from oracle 9i to 10g. Not sure if > the issue began right after that or later. > > TIA. > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
