-
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???
-
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
-
mistake
Mistake
[Edited by Chandra on 12-07-2001 at 10:00 AM]
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|