Hi,

Here I am sun soloaris E250 and Oracle8i(8.1.6). Here I am doing migration operation from Oracle 7.2 to Oracle 8i. So that I looking the information about space allocation for tablespace.

I have a Only One user but 250 tables. Each table having 100000 to 200000 laks records. How I can allocate the space for tablespace.

If anybody knows the information about this

just mail me along with one example like
create tablespace xx datafile ' /../../../xx.dbf'
storage(
initial value
next value
min extents
max extents
pctincrease value)


I need to create 16 tablespace for this migragtion work.

my Email id is shankar_gk@hotmail.com,
kgshangs@yahoo.com

Bye,

g.shankar