Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004

    Unanswered: A question about Automatic Undo Management in Oracle 9i

    I use "set transaction use rollback segment rbs_large" in my procedure before starting a large transaction. I just want to assign more rollback diskspace to this transaction, because rowcount of this transaction may exceed one million.
    It works well with Oracle 8i, but doesn't work with 9i. Oracle reports: "ORA-30019: Illegal rollback Segment operation in Automatic Undo mode".
    I found that Oracle 9i can't assign many UNDO tablespaces to ONE instance, only one UNDO tablespace is permitted for one instance.
    I want to specifiy a seperate rollback segment for this large transaction, so that it can't affair other transactions.
    Who can help me?

  2. #2
    Join Date
    Jul 2003
    1 tablespace, many datafiles.

    UNDO works totally different than how rollback segments worked.
    I suggest reading the docs and allowing/trusting Oracle to do the
    work appropriately.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Mar 2004
    Thanks very much.
    I have solved this problem.
    At last, I created a large UNDO tablespace and assigned it to current instance.

Posting Permissions

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