DEVFYI - Developer Resource - FYI

How will you create multiple rollback segments in a database ?

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

332. How will you create multiple rollback segments in a database ?

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.

(Continued on next question...)

Other Interview Questions