These aren't temporary tables....they are just plain old regular tables, that get a few rows inserted now and then. But somehow, these tables are turning into views...ie some sort of corruption!!!!!
Mike Ron Rose wrote: > Generally, if the temporary disk tables are to have zero records at the end > of the day, dropping these and creating new ones is much cleaner database > operation. > Is there some reason you need to DELETE? > RRR > > ----- Original Message ----- > From: "mike" <[EMAIL PROTECTED]> > To: "Rbase List" <[EMAIL PROTECTED]> > Sent: Monday, July 08, 2002 1:10 PM > Subject: Top ten reasons... > > > Ok wizards....one of my tables (called archdet2) disapperared. I looked > > in the system table call SYS_TABLES and I found it...but it had been > > changed into a view! I tried to change the column called SYS_TABLE_TYPE > > from VIEW to TABLE, but Rbase would not allow it. So.........what are > > the TOP TEN REASONS that this might happen? It was easy to fix, but it > > happens a lot. My database is getting pretty big (about 500 meg for all > > 4 files). Strangely, it happens to several different tables, but they > > all have 1 thing in common.....they only store rows temporarily.....they > > all have zero rows at the end of the day (the app deletes all the rows > > after the table gets used). These are NOT temporary tables! > > > > Any ideas? > > > > Mike > > > > ================================================ > > 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/
