You might be right. I haven't seen what it might be using over the past few years - though I am almost sure at one point despite the availability of ALTER TABLE in Oracle, it still did that whole table replacement thingy.
Joe _____ From: patchsk [mailto:vamsi...@gmail.com] Sent: Sunday, June 23, 2013 3:11 PM To: arsl...@googlegroups.com Cc: arslist@ARSLIST.ORG; arslist@ARSLIST.ORG; jdso...@shyle.net Subject: Re: Lost view in Database of T852 I think this is true only for DB2 and older versions of oralce, sqlserver databases. For newer versions of oracle and sqlserver the system uses direct alter table commands. It does not copy the entire table anymore. On Thursday, June 20, 2013 3:47:28 PM UTC-7, Joe D'Souza wrote: ** Its probably happened when there was a timeout when you were updating a table after adding or dropping a field. When the table restructures the Tn table gets copied to a new table TnA with the new table structure, copies the contents of Tn to TnA, and then drops Tn and renames TnA to Tn. Something in between might have failed and you probably now have a table called T885A in your database. Joe _____ From: Action Request System discussion list(ARSList) [mailto:ars...@arslist.org <javascript:> ] On Behalf Of Longwing, Lj Sent: Thursday, June 20, 2013 3:52 PM To: ars...@arslist.org <javascript:> Subject: Re: Lost view in Database of T852 ** And turn on sql logging while saving the form will tell you what the create statement is doing and hopefully give you a better idea as to why the errors are occurring On Thursday, June 20, 2013, Eamonn O'Riordan <e...@davy.ie <javascript:> > wrote: > I seem to have lost a view in the database. > > The error message I'm getting is > > ARERR [552] Failure during SQL operation to the database : Could nand turnot use view or function 'T885' because of binding errors. (SQL Server 4413)Invalid object name 'T852'. (SQL Server 208) > > This happened before about 5 years ago and the solution was to save the form again which rebuilt the view. Unfortunately, since 5 years ago, auditors have restricted the visibility of the database and I can't figure out which forms relate to T852 and T885. Anybody able to offer a suggestion? Thanks Eamonn _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"