Re: Can't see records in large table
From: joel garry <joel-garry_at_home.com>
Date: Fri, 17 May 2013 08:51:12 -0700 (PDT)
Message-ID: <1177d0a4-ac51-4bf4-a6cd-dfd1bd2dabd1_at_qz2g2000pbb.googlegroups.com>
On May 16, 4:26 pm, Guyren Howe <guy..._at_gmail.com> 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?
Date: Fri, 17 May 2013 08:51:12 -0700 (PDT)
Message-ID: <1177d0a4-ac51-4bf4-a6cd-dfd1bd2dabd1_at_qz2g2000pbb.googlegroups.com>
On May 16, 4:26 pm, Guyren Howe <guy..._at_gmail.com> 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 GB16228256 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.
jg
-- _at_home.com is bogus. We need Rockem Sockem Robots with Balmer and Page figures. http://www.cio.com/article/733546/Microsoft_responds_to_Larry_Page_remarks_but_Oracle_is_quietReceived on Fri May 17 2013 - 17:51:12 CEST