problem with undo tablespace in 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: problem with undo tablespace in 9i

  1. #1
    Join Date
    Jun 2001
    Posts
    150
    Hi
    We are just creating a test environment for oracle 9i on Open VMS 7.3.
    I have created an undo tablespace and then i have to change the compatible parameter to 9.0.0.0.0
    i also added these parameters into init.ora file
    UNDO_MANAGEMENT = AUTO # Default is MANUAL
    UNDO_TABLESPACE = undotbs_01 # The name of the undo tablespace.
    UNDO_RETENTION = 900 # The time undo is retained.
    # Default is 900 seconds.
    UNDO_SUPPRESS_ERRORS = TRUE # Suppress errors when MANUAL undo admin
    # SQL statements are issued.



    but when i restart the database it gave this error

    ora-01092


    so i remove the above parameters from the init.ora and then restart the database.

    Do you have any idea about this problem.

    how can i use the undo tablespace.

    Any idea???

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Does undotbs_01 exist? Is it UNDO type? I think one of these question has an answer = NO :-)

    If no UNDO tablespace exists, edit the init.ora file to comment out the UNDO_MANAGEMENT parameter: the default value for UNDO_MANAGEMENT is MANUAL.

    Then, after starting the database, do one of the following:

    A. Create a non UNDO tablespace with at least one online rollback segment. The instance can work this way.

    -OR-

    B. Create a new UNDO tablespace. If you want the instance to work under Automatic Undo Management,
    a. Set the UNDO_MANAGEMENT back to AUTO
    b. Set the UNDO_TABLESPACE parameter to the name of the new UNDO tablespace
    c. Restart the database



  3. #3
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192

    mistake

    Mistake

    [Edited by Chandra on 12-07-2001 at 10:00 AM]

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: mistake

    Originally posted by Chandra
    Mistake

    [Edited by Chandra on 12-07-2001 at 10:00 AM]
    What mistake?


Posting Permissions

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


Click Here to Expand Forum to Full Width