|
-
Use this solution if the rollback segment does not exist:
1. Modify the init.ora file to remove from the ROLLBACK_SEGMENTS list the name of the rollback segment that does not exist. (i.e. remove the rollback segment named in the ORA-01534 error.)
2. Save the new changes in the init.ora file and restart the database.
3. After the database opens, run the following query:
select segment_name, status from dba_rollback_segs;
Compare the output from this query with the ROLLBACK_SEGMENTS list in the init.ora fileto ensure that the ROLLBACK_SEGMENTS list is complete.
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
|