Mike I have seen this happen. In SYS_TABLES the table gets renamed as a view though there is no entry in SYS_VIEWS.
Ian At 21:15 09/04/02 -0400, you wrote: >Ok...this is weird. What would make a table just plain disappear? I >don't mean >the data, I mean the whole table is just gone! This happens >intermittently. It >is a heavily used table with lots of rules, lots of data being added and >deleted >by more than 1 user at a time. Then, for no obvious reason, the table just >disappears. I have fixed the problem by creating a file that will >recreate the >table and all of it's rules when it disappears, but I would rather try to >find a >cause. Any ideas? > >TIA > >Mike Sinclair > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
