RE: count rows that are being imported

srinivas,

Also look at using the COMMIT=Y command line prompt. This will commit the imported records every so often which would allow you to perform your select count(*) command.

Be aware that if your import plan requires a complete rollback if something bad happens, then using COMMIT=Y is probably not what you want to do, as the records are truely committed. In that case, as Bruce said, using the FEEDBACK command is probably better.

For a quick reference of commands, type IMP HELP=Y at the command line.

hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
[mailto:Bruce.Reardon_at_comalco.riotinto.com.au] Sent: Tuesday, October 02, 2001 1:30 AM
To: Multiple recipients of list ORACLE-L

Hi,

Look into imp -feedback.

>From the manual (816 Utilities, chapter 2):

FEEDBACK
Default: 0 (zero)

Specifies that Import should display a progress meter in the form of a dot for n number of rows imported. For example, if you specify FEEDBACK=10, Import displays a dot each time 10 rows have been imported. The FEEDBACK value applies to all tables being imported; it cannot be set on a per-table basis.

If your import has already started, you could possibly use logminer to query the redo / archive logs to count the number of inserted rows - I haven't tried this though.

HTH,
Bruce Reardon

-----Original Message-----
[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: Tuesday, 2 October 2001 15:10

Hi lists,

I have a tablespace that is 600 M size, has 4 million rows.

It is taking nearly 2 hrs to finish the import.

In the meantime, I tried selecting howmany rows imported(from another session), but every time I issue query,the result is zero.

But after finishing the import I got the total count.

Is there anyway to see how may rows imported in that table(in the middle or import process, from another session) ?

thnx in adv.

srinivas

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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).