| EXTENT MANAGEMENT LOCAL and SEGMENT SPACE MANAGEMENT AUTO [message #133997] |
Tue, 23 August 2005 03:22  |
stefan454
Messages: 8
Registered: August 2005
|
Junior Member |
|
|
Hello!
What is the best way of creating a tablespace for a table as below? We are running on Oracle 9.2.
That has approximatly 5000000 rows and the size are about 1Gb. The table will only have inserts and deletes and of course we will query the table.
Is it good enough with as below?
CREATE TABLESPACE <tb name> DATAFILE '.....' SIZE 1200M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
Thanks for your input!
Regards
Roger
|
|
|
|
| Re: EXTENT MANAGEMENT LOCAL and SEGMENT SPACE MANAGEMENT AUTO [message #134130 is a reply to message #133997] |
Tue, 23 August 2005 11:13  |
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
|
Senior Member |
|
|
Good enough .. If this table has got a potential growth in future , I would also consider of partitioning the table on month wise / week wise (depending upon the frequency of data load) so that you have the leisure of adding partitions / dropping partitions in future for purging the old data ...
HTH
-Sai jeedigunta
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
