Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Planning for tablespaces based on table sizes

Status
Not open for further replies.

amolso

Programmer
Sep 8, 2000
71
IN
I want create table which are of follwing type
A Small size faster growth
B small size slow growth
C BIg size alow growth
D Big size big growth

Do I keep these table in above group in same tablespaces or some of A group in one tablespace
with some tables from other groups

I am On Oracle 8.1.6 with linux
I would like to have table keeping guideleines in
a tablespace

Ajay
 
I would suggest keeping tables with large extents (probably categories C and D) in a separate tablespace than tables with small extents (A and B).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top