Re: [Beginner]Can't see records in large table
From: ddf <oratune_at_msn.com>
Date: Fri, 17 May 2013 10:45:53 -0700 (PDT)
Message-ID: <9f60fa60-4e1d-4e08-bf3e-c28f3341a6ac_at_googlegroups.com>
On Thursday, May 16, 2013 5:26:11 PM UTC-6, 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?
Date: Fri, 17 May 2013 10:45:53 -0700 (PDT)
Message-ID: <9f60fa60-4e1d-4e08-bf3e-c28f3341a6ac_at_googlegroups.com>
On Thursday, May 16, 2013 5:26:11 PM UTC-6, 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?
impdp uses resumable transactions, so if you're short on space the job will wait until the situation is corrected. You should query DBA_FREE_SPACE to see what's available in the tablespace or tablespaces this import is using. You can also check the alert log for insufficient space messages. You may need to extend the datafile or datafiles or add more datafiles to get the import to resume processing.
David Fitzjarrell Received on Fri May 17 2013 - 19:45:53 CEST