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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).