table file size 
Author Message
 table file size

I recently learned that the file for a table (class) will grow to 1G and
then a new file ('tablename.1') will be created and the table will grow into
that one, etc...

Is this tunable in any way?  Can we change that 1G value for growth or for
the base file?  

I am able to put links in place for 'tablename.1', 'tablename.2', etc.. and
they are used without error as the table grows into them, but I would like
to not have 1G taken up by the base file before it grows and uses the links
I create.

Thanks, Charlie Crissman

Charlie Crissman
Sr. Oracle DBA
Oracle Certified Professional DBA
No Boundaries Network, Inc.
904-245-6839
Pager 904-840-3684

Before you criticize someone, you should walk a mile in their shoes.  
That way, when you criticize them, you're a mile away and you have their
shoes.



Tue, 29 Apr 2003 23:15:25 GMT
 table file size

I looked for this in the code and couldn't find it, but I agree.  Being
able to set the table file size to something like 650Mb(the size of a
burnable CD) would be useful for disaster recovery solutions.

---------------------- Forwarded by Fred Zellinger on 11/10/2000 04:46 PM
---------------------------


09:08:10 AM



cc:

Subject:  [ADMIN] table file size

I recently learned that the file for a table (class) will grow to 1G and
then a new file ('tablename.1') will be created and the table will grow
into
that one, etc...

Is this tunable in any way?  Can we change that 1G value for growth or for
the base file?

I am able to put links in place for 'tablename.1', 'tablename.2', etc.. and
they are used without error as the table grows into them, but I would like
to not have 1G taken up by the base file before it grows and uses the links
I create.

Thanks, Charlie Crissman

Charlie Crissman
Sr. Oracle DBA
Oracle Certified Professional DBA
No Boundaries Network, Inc.
904-245-6839
Pager 904-840-3684

Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their
shoes.



Wed, 30 Apr 2003 06:55:10 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Table file size doesn't change.

2. File size difference between table in database and exported file

3. SQL Server database file size versus Oracle File size

4. Import large Text file of 50 MB size to a table in sqlserver 7.0

5. file table size

6. File size of table grows in certain directories

7. How to calculate table size in mdb files?

8. Problems with adding new attribute to table and file sizes

9. File size of table grow/Add'l info

10. How to calculate table size in mdb files?

11. Questions about file allocated size, used size in SQL Server 7.0


 
Powered by phpBB® Forum Software