One more clue.....none of these tables have any permanent data....always 0 rows until the app needs them, and then they are cleared shortly thereafter.
Mike ----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 11:48 PM Subject: RE: disappearing tables > Mike, > > What is the name of your table, and what is the name of your view? > Maybee you are having a problem related to 8 character names. > > Troy > > >===== Original Message From [EMAIL PROTECTED] ===== > >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/ > > Troy Sosamon > Denver Co > [EMAIL PROTECTED] > > ================================================ > 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/
