InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Will You Create Multiple Rollback Segments In A Database ? |
|
Answer» Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment NAME R0 in the SYSTEM tablespace. Make NEW rollback segment available (After shutdown, modify init.ora file and START database) Create other tablespaces (RBS) for rollback segments. Deactivate Rollback Segment R0 and activate the newly CREATED rollback segments. Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make new rollback segment available (After shutdown, modify init.ora file and Start database) Create other tablespaces (RBS) for rollback segments. Deactivate Rollback Segment R0 and activate the newly created rollback segments. |
|