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???