Re: IMP stalls (???)

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 20 Jun 2005 15:36:40 GMT
Message-ID: <coBte.358$N22.150@newssvr21.news.prodigy.com>

IANAL_VISTA wrote:

> "David_T (MO)" <d_thomas02_at_hotmail.com> wrote in 
> news:1119280353.909587.174480_at_f14g2000cwb.googlegroups.com:
> 
> 

>>I'm using Oracle 8i and am trying to keep a backup database current
>>with our Production database. We do a daily full EXP of Production and
>>then weekly IMP the latest dumpfile into the backup database. Normally
>>this has only taken an hour to complete but lately it appears to be
>>stalling early in the import after the following lines:
>>

[...]
>>. . importing table "DEF$_PUSHED_TRANSACTIONS" 0 rows
>>imported
>>
>>After about eight hours it will continue with the next line and then
>>run to completion at a normal pace.
>>
>>. . importing table "DEF$_TEMP$LOB" 0 rows
>>imported
>>

> 
> TRACE the session & find out what's happening under the hood.
> 

Check Metalink Note:213872.1, which appears to exactly match your problem.

Is this truly a "backup" database, or rather one used for testing and other purposes? A logical backup (export) is far from the best way to protect your running production database in real time.

Beyond that, you would probably be better off to use the OWNER=... option of EXP to specify the specific schemas you wish to export, without doing a FULL export. Simply drop the schema(s) first in the "backup" database, then import the fresh dump.

-Mark Bole Received on Mon Jun 20 2005 - 10:36:40 CDT