Re: how to find current insterd record during import

On May 17, 9:32 pm, Dax <daxesh2..._at_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/uniontrib/20070518/news_1b18donlan.html