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.


Discussion

No Comment Found

Related InterviewSolutions