"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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------