Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: IMP stalls (???)

Re: IMP stalls (???)

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Mon, 20 Jun 2005 15:18:58 GMT
Message-ID: <Xns967B549904676SunnySD@68.6.19.6>


"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 SYS's objects into SYS
> . importing SYSTEM's objects into SYSTEM
> . importing SYS's objects into SYS
> . importing SYSTEM's objects into SYSTEM
> . . importing table "DEF$_AQCALL" 0 rows
> imported
> . . importing table "DEF$_AQERROR" 0 rows
> imported
> . . importing table "DEF$_CALLDEST" 0 rows
> imported
> . . importing table "DEF$_DEFAULTDEST" 0 rows
> imported
> . . importing table "DEF$_DESTINATION" 0 rows
> imported
> . . importing table "DEF$_ERROR" 0 rows
> imported
> . . importing table "DEF$_LOB" 0 rows
> imported
> . . importing table "DEF$_ORIGIN" 0 rows
> imported
> . . importing table "DEF$_PROPAGATOR" 0 rows
> imported
> . . 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
>
> Does anyone have any ideas whats causing the stall?
>
>

TRACE the session & find out what's happening under the hood. Received on Mon Jun 20 2005 - 10:18:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US