Re: Can't see records in large table

From: joel garry <>
Date: Fri, 17 May 2013 08:51:12 -0700 (PDT)
Message-ID: <>

On May 16, 4:26 pm, Guyren Howe <> wrote:
> I get 0 records still. My current working hypothesis is that the original import failed, though.
> My current impdp job mentioned above isn't obviously doing a whole lot. The log hasn't updated in an hour or more, but it hasn't finished.
> Doing status in the impdp prompt says the job is executing, bytes processed is 0, and the percent done is 100. This hasn't changed in a couple of hours. Might impdp have stalled for some reason without so indicating?
> Is it possible that impdp is importing everything in a transaction, and I won't see the results in a different sql prompt until it has completed?

An import log would show things like:

. . imported "YOURSCHEMA"."YOURTABLE"                     1.169 GB
16228256 rows

But of course it wouldn't say that until the table is done, and there could be a delay writing the output filling output buffers.


-- is bogus.
We need Rockem Sockem Robots with Balmer and Page figures.
Received on Fri May 17 2013 - 17:51:12 CEST

Original text of this message