I would take a look at v$session_wait whilst the
import is running and see what pops up.
My understanding of NESTED_TABLE_SET_REFS is to get at
the hidden columns when object data types are used.
I'm not sure why it always seems to be so prevalent in
import - possibly they just do it with any old table
and the hint is ignored except in the object case
hth
connor
- Ron Rogers <RROGERS_at_galottery.org> wrote: > List,
> Source database 7.3.4 OS Novell 4.2
> Target database 8.1.7 OS Linux RedHat 7.2
>
> Table is 5 columns ,indexes on columns 1,2PK, 1,3
> , 3 for application
> usage
> Export of a table is 750K rows and takes about 2
> minutes with a DMP
> file the size of 20 Meg.
> Import command in the V$SQLAREA shows "INSERT
> /*NESTED_TABLE_SET_REFS*/
> INTO "DRITV" ("COL1","COL2","COL3","COL4","COL5")
> VALUES(:1,:2,:3,:4,:5)" and takes 1.5+ hours. The
> table is truncated
> because this is a copy of data from production to a
> test database.
> Question is why could it be taking such a long time
> to load and I have
> not been able to find the hint info in my of my
> doc's. The table is not
> a nested table and the hint confuses me. What does
> it mean.
> I am going to truncate the table again and do a copy
> across the network
> to get the time for that action.
> Thanks,
> Ron
> ROR mª¿ªm
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Feb 28 2002 - 16:09:22 CST
