Database Tuning (MOSC)

MOSC Banner

Undo_tablespace

edited Feb 8, 2010 11:57PM in Database Tuning (MOSC) 1 commentAnswered
 Hi,
I am in a process of db upgrade from 8.1.7.4 to 10.2.0.4 and hence I want to create undo tablespace.I found a metalink note but it is not suitable for my scenario:
Init.ora Parameters
-------------------

  1. UNDO_MANAGEMENT parameter must be set to AUTO.

  2. UNDO_TABLESPACE = <tablespace name> : This parameter allows the instance
     to use the specified UNDO TABLESPACE during instance startup, in case
     more than one undo tablespace exists.
 
     For eg:  UNDO_TABLESPACE = rbs
   
     This parameter need not be declared in init.ora at database creation time.
      

Creating an undo tablespace during database creation:
-----------------------------------------------------

In the CREATE DATABASE statement, use the UNDO TABLESPACE clause to specify the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center