Do you have Rscope? You should try to look at that table with Rscope when it disappears.
Let me make sure I understand this problem. You have a table and lets call it TABLE1, and you have a view VIEW1 that drives off of TABLE1. If you do a LIST command, VIEW1 shows up, but TABLE1 does not. If you do SELECT * FROM VIEW1, the data from TABLE1 shows up. If you do SELECT * FROM TABLE1, what happens? Troy ===== Original Message from [EMAIL PROTECTED] at 6/25/02 12:05 pm >Reloading does not make it go away. And I can't fix it if there is more >than 1 user attached. To fix it, I have to disconnect everybody, then drop >the table that does not exist, and then recreate the table. Then everything >is fine....until it happens again! > >Mike >----- Original Message ----- >From: "mjs" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, June 25, 2002 12:15 PM >Subject: disappearing tables > > >> Ok....somebody must be seeing this. For no obvious reason, some of my >> tables are just plain disappearing....and they seem to be showing up in >the >> view table. How is this possible? What might be broken? >> >> 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/ ================================================ 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/
