I was updating a table last night with a def file. I ran into problems with some of the fields. Odd errors that didn't make sense like ORA-00904: "C536870914": invalid identifier. Being a good admin, I exported the forms before I made the update. I'm still getting the invalid identifier errors but I'm also getting the ORA-00942 errors.
It looks like with the update, the table was renamed to 140A as I would have expected but we ran out of temp space and the process didn't complete. We're stuck and can't update the form because it sort of doesn't exist from the admin tool perspective. I can see the form. I can open it. I can add or delete a field but the saves error because the view doesn't exist. Anyone run across this situation before? I think I understand what we need to do but It's been a long night so I need folks to look over my shoulder while support is pouring over the arerror and sql log files. Here's what I think we need to do: Shut down the app server. Back up the database. Rename the 140A table to 140. Reapply the definition files to back out the failed changes. Lack of sleep has made my brain fuzzy but does this sound like what needs to be done? Dave Dave Shellman Phone: (717) 810-3687 Fax: (717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
