Re: Oracle 9i datafile sizes compared with 8i

"Austin" <austint_at_vsnl.com> wrote in message news:I06oqA.GsB_at_news.boeing.com...
> 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?
>

Perhaps the target database (9i) character set is a multi-byte cs, so that conversion from single-byte character set to multi-byte character set is taking place during import...

Regards Received on Fri Jul 02 2004 - 06:22:39 CDT