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" > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
