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 prob
Srinivas,
Do you have any indexes, constraints, triggers on this table
When trying to import.
Cause this can reduce import performance substantially.
Just to let you know, on a DELL 6450 Windoze NT Server, I get can import 2
million records per minute as long as there are no indexes or constrain
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