Troy, Not quite....I don't have any view called TABLE1.....just a table called TABLE1. For no obvious reason the table just plain disappears. Then, if I do a LIST VIEWS....it is there...sort of ....but it does not work (ie, browse all fro TABLE1 tells me no such view exists)!
Mike ----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 3:03 PM Subject: RE: disappearing tables > 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/ > ================================================ 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/
