Re: Export / Import from 8i to 9i and locally managed tablespace

Hi,

Yes by default segment space auto is 1M extent, you can specify 'segment space management manual' when you create your tablespace...

achkar wrote:
> Hi All ,
>
> I have a table on oracle 8i (8.1.7 ), this table resides on dictionary
> managed tablespace: initial size 256k , next size 256k, that is for
> both the table and the tablespace .
> then I did export to that table with no merge.
> after that I created locally managed tablespace on 9i with uniform
> allocation 520k ,segment space management is automatic
>
> When I did the import I noticed that the initial size for that table
> on 9i is 1096K instead of 520K , Why is that? , is it because 'segment
> space management is automatic '
> and if so , how can I stop that , I would like to know what will
> happen if my table is really big ( 20 million record ) , what will
> happen to the initial size for that table when I do the import. or do
> I need to create the table on 9i then do the import.
>
> any help / opinion / thoughts will be appreciated.
Received on Tue Apr 08 2003 - 05:10:28 CDT