Re: Oracle 9i datafile sizes compared with 8i

On Thu, 1 Jul 2004 17:32:35 GMT, "Austin" <austint_at_vsnl.com> wrote:

>Hi DBAs,
>
>I am facing some problems importing an 8i export file into 9i instance.
>
>I have created tablespaces with same sizes in 9i before the import (used the
>"create tablespace.." command from the export dmp file). I find that the
>tablespaces are getting full prematurely into the import. I would expect the
>9i tablespace to hold the same amount of tables/records as the 8i tablespace
>of the same size. But after I set an initial extent to about twice the size
>of the 8i tablespace and retry, the import works fine.
>
>My question is - Is there a difference in the way 9i datafiles are managed
>compared to 8i datafiles, or have I missed setting some parameter on the 9i
>instance?
>
>Thanks in advance.
>
>Austin.
>

There is no difference.
Likely you didn't use the 'compress=n' parameter on your export, and this is causing your problems. The result of this all your tables will be created in one extent per table, instead of n extents. If you have set your datafiles to autoextend, not finding contiguous free space using the 'new' storage parameters will result in the datafiles to extend.

--
Sybrand Bakker, Senior Oracle DBA