| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-30044 under 9i?
I've enabled resumable space under Oracle 9.2.0.6 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
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com <mailto:dherri_at_acxiom.com> >
"When I come home from work and see those little noses pressed against the windowpane, then I know I am a success" - Paul Faulkner
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Sep 10 2006 - 19:49:12 CDT
 |
 |