Yes it would, because you could edit the structure file and not have to edit the data file.
You would just need to delete out the occurance on the weird table. Now when you re-build the database, you run the structure file first and it will build the db w/o the weird table. Now when you run the data file to load all of the data back in the tables everything will run fine and when it trys to load the weird table, it won't be in the database so it will spit out some errors, but should load everything else fine. You don't care about those errors because you didn't want that table any way. Personally I would not use the method on a large database. I would be too afraid of loosing rows. I would use R:scope and fix the database with that. If your #2 file is 1.7 gigs it will take forever to do this anyway, and I am certain you could justify the $130 for R:scope. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rommel Relosa Sent: Friday, June 20, 2003 11:32 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SYS_TABLES TABLE With a #2 file running at 1.7 GB, I don't it would matter if I unloaded the structure separately. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Troy Sosamon Sent: Friday, June 20, 2003 10:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SYS_TABLES TABLE That is why I always do it in 2 parts, an schema file and then the data file. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rommel Relosa Sent: Friday, June 20, 2003 11:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SYS_TABLES TABLE UltraEdit... Thanks, Dennis. Every one I tried just couldn't load the 780 MB file. Rommel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dennis McGrath Sent: Friday, June 20, 2003 6:23 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SYS_TABLES TABLE For Editing really huge unload files, try UltraEdit. Awesome! I've done files larger than a gig. It just won't choke. Dennis McGrath --- Rommel Relosa <[EMAIL PROTECTED]> wrote: > Dan, > > If you don't have RScope (yet <g>), you can try this to remove the > funky > table. > > CONNECT <DBNAME> > OUTPUT UNLOAD.DAT > UNLOAD ALL > OUTPUT SCREEN > > > Now, if the file is not too big, use a text editor and look for the > CREATE > TABLE `funkyname` entries and remove it. > > Then, look for the section with LOAD funkyname and delete the "load" > entries. > > Rename the database (back up purposes, in case reload fails <g>) then > issue: > > INPUT UNLOAD.DAT > > This will rebuild the database without the table with the funkyname. > > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dan > Goldberg > Sent: Thursday, June 19, 2003 1:51 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - SYS_TABLES TABLE > > > Does anybody know how to edit the sys_tables table?? > > I have a table that has a funky name that I can not get a rid off. > > > Dan Goldberg >
