Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-30044 under 9i?

ORA-30044 under 9i?

From: Herring Dave - dherri <>
Date: Sun, 10 Sep 2006 19:49:12 -0500
Message-ID: <>

I've enabled resumable space under Oracle and have now run into a painful issue. This database is a data warehouse with remote transactions used over dblinks to build datamarts. Unfortunately, I'm getting the following on any transaction from the remote database to the DW:  

ORA-30044: Resumable cannot be enabled with distributed transactions

ORA-02063: preceding line from <dblink name>  

Under 9i you have to enable resumable space using an AFTER LOGON trigger. So I've got one setup to just issue:  

      EXECUTE IMMEDIATE 'ALTER SESSION ENABLE resumable timeout 7200';  

That's what the doc suggests to do. I could join to sys.x$k2gte before executing the above, but this doesn't account for transactions initiated from the DW to a remote database, which gives:  

ORA-30044: Resumable cannot be enabled with distributed transactions  

Because of the latter, it sounds like my only option is to give up on the trigger idea and have the developers insert the ALTER SESSION in any code they know is remote and prone to large space usage. Pretty lame, but I'm not sure what else can be done.  

Anyone run into this and found a hack around this issue?  


Dave Herring, DBA

Acxiom Corporation

3333 Finley

Downers Grove, IL 60515

wk: 630.944.4762

< <> >


"When I come home from work and see those little noses pressed against the windowpane, then I know I am a success" - Paul Faulkner  

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.

Received on Sun Sep 10 2006 - 19:49:12 CDT

Original text of this message