Re: Set rollback segment online

From: Chakravarthy KM Nalamotu <kittu_at_Hawaii.Edu>
Date: 14 Sep 1999 15:08:09 GMT
Message-ID: <7rlocp$gsg$1@news.hawaii.edu>

Use the following package inside your procedure. DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT('pub_rs1'); If you commit every 'n' updates, be sure to have the above statement right after the commit.

Daiminger, Helmut (Helmut.Daiminger_at_gedas.de) wrote:
: Hi,

: can I set a rollback segment online within a PL/SQL package?

: begin
: ....
: alter rollback segment PUB_RS1 online;
: ...
: end;

: Thanks,
: Helmut
Received on Tue Sep 14 1999 - 10:08:09 CDT