Re: Import hanging - help!

From: Stephane Faroult <sfaroult@xxxxxxxxxx>

To: oracle-l@xxxxxxxxxxxxx

Date: Mon, 26 Apr 2004 15:00:00 +0200

"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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------