Table is Full Error 
Author Message
 Table is Full Error

Running Paradox 5.0 (although the table in question is Paradox 4.x) I am
trying to insert 150,000 records from one table into another and get a
"table is full" error.  The documentation says that a table can be
2,000,000,000 rows.  So why does it think this table is full? Is tablesize
limited somewhere else?

Thanks for your help.

Jereme

_______________________________________________________________
Jereme Chapman
Box 4034
Mississippi State, MS 39762
(601) 338-0022
http://www.***.com/



Fri, 08 Oct 1999 03:00:00 GMT
 Table is Full Error

Quote:
> Running Paradox 5.0 (although the table in question is Paradox 4.x) I
> am trying to insert 150,000 records from one table into another and get
> a "table is full" error.  The documentation says that a table can be
> 2,000,000,000 rows.  So why does it think this table is full? Is
> tablesize limited somewhere else?

Create a new table, version 5, and using the BDE make the block size
optimum for the size of your record.

Daniel A. Morgan



Fri, 08 Oct 1999 03:00:00 GMT
 Table is Full Error

Quote:

> Running Paradox 5.0 (although the table in question is Paradox 4.x) I am
> trying to insert 150,000 records from one table into another and get a
> "table is full" error.  The documentation says that a table can be
> 2,000,000,000 rows.  So why does it think this table is full? Is tablesize
> limited somewhere else?

Open the table with Table Repair, and find out the size of a record.
Now the table is probably set to the default with an 8K block size,
which with a limit of 64K blocks means a max table size of 512M.

With 150K records, that means the record size must be less than
512M/150K = ~3K in size.

You can change the block size with Table Repair, if necessary.
If the record size is less than 3K, something else is wrong.
Please post further details if that is the case.

Hope this helps.
--
****************************************************

* SCF Consulting, Calgary, AB
*
* 'There are more objects in Mainframe and the Net
*  than are formulated in your paradigm, Bob'
****************************************************



Sat, 09 Oct 1999 03:00:00 GMT
 Table is Full Error

Jereme: the number of records, and size of table,
are determined by the block size.. the default of
2k blocks allows a 128 meg table.. increasing this
(to a max of 32k blocks) can increase a table to
2 gig max.. the number of records will depend on the
size of the records..

The block size is set by BDE (IDAPI)..

--
Steve Green - Diamond software Group - Waldorf Maryland USA

and Corel's CTech tech support staffs but I don't represent
Borland International or Corel in any official capacity.



Sun, 10 Oct 1999 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. error ORA-01855: AM/A.M. or PM/P.M. required

2. I am searching for a full documenter fro SQL7.0

3. I am searching for a full documenter for SQL7.0

4. Full table causing error??

5. Full table causing error??

6. Full table causing error?

7. Full Text Search (dropping a table gives error)

8. Table is full error

9. D1: Table Is Full Error Question...

10. Table full / directory is busy error

11. "Table is full" error

12. Table Full error message on PdoxDos 4.5


 
Powered by phpBB® Forum Software