Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Unanswered: use big rollback segment

    I know that there is an option of changing the rollback segment of the current session, but I do not seem to find the syntax in the docs,

    help, anyone ?

    Tal (otal@mercury.co.il)

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: use big rollback segment

    Originally posted by tal_olier
    I know that there is an option of changing the rollback segment of the current session, but I do not seem to find the syntax in the docs,

    help, anyone ?

    Tal (otal@mercury.co.il)
    It is in the SQL Reference:

    SET TRANSACTION USE ROLLBACK SEGMENT <name>;

    It has to be the first statement in a transaction to work.

  3. #3
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Re: use big rollback segment

    Originally posted by andrewst
    It is in the SQL Reference:

    SET TRANSACTION USE ROLLBACK SEGMENT <name>;

    It has to be the first statement in a transaction to work.
    Thanks.

  4. #4
    Join Date
    Dec 2002
    Posts
    1

    Re: use big rollback segment

    at SQL prompt > set transaction use rollback segment <rbs name>;

    --shah


    Originally posted by tal_olier
    I know that there is an option of changing the rollback segment of the current session, but I do not seem to find the syntax in the docs,

    help, anyone ?

    Tal (otal@mercury.co.il)

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    Also make sure you don't have uncommited transaction before setting the RBS, or you might get this:

    SQL> set transaction use rollback segment RBS1;
    set transaction use rollback segment RBS1
    *
    ERROR at line 1:
    ORA-01453: SET TRANSACTION must be first statement of transaction


    SQL> commit;

    Commit complete.

    SQL> set transaction use rollback segment RBS1;

    Transaction set.

    SQL>

    May be you can commit first...


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •