Re: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow!

Try running a 10046 trace on the import session. If the import is being done across the network you may find that imp is very chatty.

Jared

On 4/15/05, Marquez, Chris <CMarquez_at_aarp.org> wrote:
>
> --Env
> Oracle 9206
> AIX 5.x
>
> I don't have much experience with "User Defined Datatypes" nor "XML
> Datatypes".=20
> Trying to move a database for a client that uses these datatypes.
> (not sure but maybe some of them are Nested Tables or VARRAY's vs. "User
> Defined Datatype"...how can I tell the difference?)
>
> Anyway, in the same database I can IMPort
> * 15GB-20GB normal data (no indexes) per hour.
> * 10GB GB BLOB data per hour.
> but only
> * 324MB of "User Defined Datatypes" After 1 Hr. 15 Min.
> * 53MB of "XML Datatype" After 30 Min.
>
> --

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l