Re: Import hanging - help!

"Smith, Ron L." wrote:
>
> I have a compressed import hanging.
> I found the following code in the system: ALTER SESSION SET EVENTS
> '22825 TRACE NAME CONTEXT FOREVER, LEVEL 1'
>
> I tries transaction_auditing =3D false in the init file but it didn't
> work. =20
> How do I turn this off?
>
> Thanks!
> Ron

Ron,

>From $ORACLE_HOME/rdbms/mesg/oraus.msg :

22825, 00000, "event set during import/export"

// *Document: NO
// *Cause:    N/A
// *Action:   Enables logical transformation of opaque types

It doesn't seem to have anything to do with transaction auditing. In fact, it furiously looks like an Oracle bug. Not as opaque as it should. If I were you, I'd try (possibly through V$SESSION) to identify which statement hangs and file a tar. And in the meanwhile I'd try to skip the problem table and try various ways to get its data (uncompressed, not direct export springs to mind).

-- 
Regards,

Stephane Faroult
Oriole
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------