Hi Atrix, I wouldn't do it. 1 plus 1 is still 2. You and the other guys, and they're changing the tables you're altering.
Dave Billing Tall Tree Business Solutions ----- Original Message ----- From: "Atrix Wolfe" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 3:45 PM Subject: [RBASE-L] - RE: Alter Table (was SYS_TABLES TABLE) > > hmm, how about with r:tango? I heard that it works like a single r:base > user just doing a whole lot of stuff. > > Since its a single user, would this affect the risk any? > > hoping for a good answer! > > thanks, > Atrix > > ----- Original Message ----- > From: "Albert Berry" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, June 20, 2003 12:36 PM > Subject: [RBASE-L] - RE: Alter Table (was SYS_TABLES TABLE) > > > > The short answer is an emphatic YES. I never make structural changes of > this type when users are in the system. It is ok to add a new tables most of > the time, but modifying table structures is taking a big chance. I prefer > not to even add new tables with other users connected. > > > > > > "Atrix Wolfe" <[EMAIL PROTECTED]> wrote: > > > > >is there any risk of corrupting a database/table doing something like: > > > > > >alter mytable add amount currency > > > > > >while users are using the system? > > > > > > > > >----- Original Message ----- > > >From: "Troy Sosamon" <[EMAIL PROTECTED]> > > >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > > >Sent: Friday, June 20, 2003 11:31 AM > > >Subject: [RBASE-L] - RE: SYS_TABLES TABLE > > > > > > > > >> When you unload the schema for your database, it will be a very small > file > > >> and you can edit it with just about anything. > > >> > > >> connect mydatabase > > >> out mydb.sch > > >> unload schema > > >> out screen > > >> > > >> The file won't be over 500 k. > > >> > > >> You unload just the data to a seperate file. > > >> > > >> On a big database, I would write a program that would unload the data > for > > >> each table to seperate file. This keeps everything managable and you > can > > >> edit the files if you need to. On the really large tables, you might > even > > >> want to put them in multiple files. I would try to keep the files below > > >100 > > >> megs each. > > >> > > >> Troy > > >> > > >> > > >> -----Original Message----- > > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rommel > > >> Relosa > > >> Sent: Friday, June 20, 2003 11:53 AM > > >> To: RBASE-L Mailing List > > >> Subject: [RBASE-L] - RE: SYS_TABLES TABLE > > >> > > >> > > >> No, it wouldn't since the data file will be 700 MB instead of 780 MB, > and > > >at > > >> the time, I don't have a text editor that can load such a beast. > > >> > > >> > > >> And, I do have RScope, Troy. :) > > >> > > >> I've used it to rebuild the database structure pointer-by-pointer to > > >correct > > >> a corruption problem on the SYS_COLUMNS table. Never again would I > modify > > >> an unused table when 30 users are hitting the database at the same > time. > > >> Hard lesson to learn, but, with RScope my colleagues and I were able to > > >> recover the structure of the database and had very minimal (if any) > data > > >> loss. > > >> > > >> > > >> 'Tis why I recommended it to Dan a few posts back. > > >> > > >> > > >> > > >> > > >> > > >> -----Original Message----- > > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Troy > > >> Sosamon > > >> Sent: Friday, June 20, 2003 10:41 AM > > >> To: RBASE-L Mailing List > > >> Subject: [RBASE-L] - RE: SYS_TABLES TABLE > > >> > > >> > > >> 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 > > >> > > > >> > > > > > > > > > > > > -- > > Albert Berry > > Full Time Consultant to > > PSD Solutions > > 350 West Hubbard, Suite 210 > > Chicago, IL 60610 > > 312-828-9253 Ext. 32 > > > > > > __________________________________________________________________ > > McAfee VirusScan Online from the Netscape Network. > > Comprehensive protection for your entire computer. Get your free trial > today! > > http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 > > > > Get AOL Instant Messenger 5.1 free of charge. Download Now! > > http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 > > > > >
