Hi,

My import is going on Oracle 8.1.7.4.0. My one of the table has more
then 10,000,000 records. Now I want to know is their any way I can
find out how much currently record inserted in table during import.
Means I want to view current progress of data insert in table.

Dax

On May 18, 8:32 am, Dax <daxesh2...@gmail.com> wrote:
> Hi,
>
> My import is going on Oracle 8.1.7.4.0. My one of the table has more
> then 10,000,000 records. Now I want to know is their any way I can
> find out how much currently record inserted in table during import.
> Means I want to view current progress of data insert in table.
>
> Dax

See FEEDBACK parameter in the IMP docs.

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

On May 17, 9:32 pm, Dax <daxesh2...@gmail.com> wrote:
> Hi,
>
> My import is going on Oracle 8.1.7.4.0. My one of the table has more
> then 10,000,000 records. Now I want to know is their any way I can
> find out how much currently record inserted in table during import.
> Means I want to view current progress of data insert in table.
>
> Dax

It's getting a bit hazy these days, but I think I used to use metalink
Note:1039126.6 to have a clue where in an import I was. There are
other scripts for looking into rbs that are quite different, google
about.

If you are not already, and depending on your circumstances, you might
consider doing indices after the import rather than as part of it.

Have you tried doing a count of the table from another session
(depending on how you are committing - commit=y will make the count
somewhat close, commit=n will be way off)?

jg
--
@home.com is bogus.
"I'm a very good investor, don't worry about a thing."
http://www.signonsandiego.com/uniont...b18donlan.html