Dee, A work-around would be to unload the data and structure separately, modify the structure file, create a new database from that, and then load the data.
I cannot speak to the .RX3 filesize issue, but know that when you issue an ALTER TABLE command where the table has indexes, it will first of all duplicate the table in the .RX2 file then completely rebuild the indexes. When indexes get rebuilt, they will consume new space in the .RX3. So, my suggestion is: OUTPUT dbname.str UNLOAD structure OUTPUT dbname.dat UNLOAD data OUTPUT SCREEN Now, edit dbname.str to change your column to REAL, move the old database out of the way, RUN dbname.str then RUN dbname.dat. Here's another suggestion: when you are editing the dbname.str file, put the CREATE INDEX commands into a separate file and remove them from the .str. Run that file last, and the data will load much more quickly because it isn't maintaining the indexes as each row is loaded. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dee Georgeson Sent: Thursday, April 08, 2010 13:40 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Turbo V-8 RX3 file size Steve, I just checked the properties on my rx3 file and it does indeed report exactly 2.00GB. Mark, I agree that based on the data on the Rbase website I "Shouldn't" have that problem. What I'm reporting is that I "am" having that problem. Unless there is another reason that my alter table command stops and reports that it can't update the table.....? Dee -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Steve Martin Sent: Thursday, April 08, 2010 10:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Turbo V-8 RX3 file size Additionally, after the modification had stopped, rows could still be added to the database so long as the table being added to was not indexed. The limitation, regardless of why, was on the .RX3 file. That it bumped its head at exactly 2.0 gb is suspicious at best. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dee Georgeson Sent: Thursday, April 08, 2010 11:19 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Turbo V-8 RX3 file size Gentle People, I would like to reopen this issue since no one actually answered the question. Let me ask it directly: Is there a file size limitation to the database files in Rbase Turbo V8? I believe the answer to be yes based on the following information. Would someone please confirm? Computer Specifications: Intel(r) Core (tm) CPU 6600 @2.4GHz 2.00GB RAM 32-bit Operating System Windows Vista(tm) Business SP 2 I am running R:base Turbo V-8 Build 8.0.22.30331 Hard Drives: C: 74.5GB, 53.6GB used, 20.8GB free D: 38.2GB, 21.8GB used, 16.3GB free The database is on the D: drive. Starting Database File Size: 04/08/10 09:39 AM 272,404 earl.RX1 04/08/10 09:39 AM 2,228,224,000 earl.RX2 04/08/10 09:39 AM 1,510,752,256 earl.RX3 04/08/10 09:39 AM 7,983,104 earl.RX4 History Table Specifications: No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 HID Type : INTEGER NOT NULL AUTONUMBER Consrnt: PRIMARY KEY REFERENCED 2 PartRef Type : INTEGER Consrnt: FOREIGN KEY REFERENCES Invent 3 PartNo Type : TEXT 50 Index : SINGLE-COLUMN 4 SerialNo Type : TEXT 15 Index : SINGLE-COLUMN 5 Status Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES Status 6 DocNo Type : TEXT 12 Index : SINGLE-COLUMN 7 DocType Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES DocType 8 Qty Type : INTEGER 9 PrevAssn Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES Assignment 10 CurAssn Type : TEXT 2 Consrnt: FOREIGN KEY REFERENCES Assignment 11 PrevLoc Type : TEXT 16 Index : SINGLE-COLUMN 12 CurLoc Type : TEXT 16 Index : SINGLE-COLUMN 13 WoSeg Type : TEXT 4 14 TranDate Type : DATE 15 TranAmt Type : CURRENCY 16 ReqNoItem Type : TEXT 10 Index : SINGLE-COLUMN 17 Notes Type : NOTE 18 LastStatus Type : TEXT 1 19 EmpNo Type : TEXT 9 Consrnt: FOREIGN KEY REFERENCES Employee 20 DTStamp Type : DATETIME Index : SINGLE-COLUMN Current number of rows: 3,106,019 I set messages on, error messages on, and feedback on. I execute this command: alter table history alter column tranamt real The rows update successfully. Rows then start collecting for Index Creation. Feedback doesn't show which index is being created. After many indexes are created the program stops with this error message: -ERROR - Unable to create/modify table (2832) File sizes after disconnecting from the database: 04/08/10 10:06 AM 277,906 earl.RX1 04/08/10 10:06 AM 2,980,267,268 earl.RX2 04/08/10 10:06 AM 2,147,484,672 earl.RX3 04/08/10 10:06 AM 7,983,104 earl.RX4 Since the error message doesn't tell me anything about why it couldn't modify the table, I'm left to assume that there is a file size limitation to these files. If this isn't the case, please tell me what is happening. Thank You for your consideration. Dee Georgeson Erickson Air-Crane Inc -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, February 12, 2010 5:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Turbo V-8 RX3 file size At 04:37 AM 2/12/2010, Doug Hamilton wrote: >The file size "limitation" is a function of the 64 bit implementation, >regardless of the name of the file. >Doug >p.s. That means even the RX1 could be > 2Gb. However, one may want to >review their db structure in that case :) . Implementation of 64-bit data pointers in Turbo V-8 . Ability to name INDEXes up to 128 Characters http://www.rbase.com/products/compare.php In addition, I would be curious to see the LIST of INDEXes, PKs, FKs, and UKs in that particular Turbo V-8 database. CONNECT dbname IDENTIFIED BY ownername user SET NAMEWIDTH 40 SET LINES 0 LIST INDEX LIST PKeys LIST FKeys LIST UKeys Very Best R:egards, Razzak. P.S. http://www.rbase.com/rbg90/compare.php No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2792 - Release Date: 04/07/10 12:32:00
