RE: import...dead or alive?

If the output says X rows imported and it's just sitting there, then it is probably building indexes and/or enabling constraints. On the tables around here, I can usually figure on the index and constraint part making up about 80% of the total time. You can select the index_name's and constraint_name's to see if they are going up. And you can look for those temporary segments with numbered names that Oracle uses when it is building indexes.

If the import is still bringing in the data, you can select count(*) from the table. Import also has a feedback setting you can use ... but not after you have already started the import.

> -----Original Message-----
> From: Saira Somani [mailto:saira_somani_at_yahoo.com]
> Sent: Wednesday, April 30, 2003 9:07 AM
> To: Multiple recipients of list ORACLE-L
> Subject: import...dead or alive?
>
>
> How can I find out if an import is dead or alive? I have an import of
> 1.6M+ rows that's been running for over 45 minutes.
>
> Oracle 8.1.7.0.0
> AIX 4.3.3
>
> What can I check?
>
> Thanks,
> Saira
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Saira Somani
> INET: saira_somani_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).