FYI...
Thanks for the info.... and the warning.
I ended up using:
$dbh->do('set transaction use rollback segment rbs_large01') || warn
$dbh->errstr;
I've been stung by not re-setting the rollback segment after a commit in the
past, so I accounted for that too.
-John
-----Original Message-----
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 1:24 PM
To: Guidarelli, John; 'DBI Users'
Subject: Re: DBD::Oracle - specifying rollback segments
On Tue, 30 Jul 2002 12:50:25 -0700 "Guidarelli, John"
<[EMAIL PROTECTED]> wrote:
> Is there anyway to specify the rollback segment to use in Oracle via the
> DBD::Oracle module?
>
> I did not see anything in the DBD::Oracle or DBI perldocs other than the
> begin_work DBH Object (which doesn't take any parameters).
The statement for assigning a rollback segment (ALTER SESSION, I think) is
Oracle SQL. You can execute it with prepare()/execute() or do() just like
any other non-SELECT statement.
Be aware that COMMIT releases the segment so you need AutoCommit off.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
