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:[EMAIL PROTECTED]] 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:[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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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).