Create Database   «Prev  Next»

Creating Additional Rollback Segments - Exercise

Create Initial Rollback Segments

Objective: Create some rollback segments for the COIN database.

Exercise scoring

This exercise is worth a total of 20 points.

Instructions

Write the necessary CREATE ROLLBACK SEGMENT commands to create four rollback segments in your database. Use an initial extent size of 256k, a next extent size of 256k, and create the segments with a minimum of two extents each.
After you have submitted your statements to the tutors for grading, you will see my solution. Make any changes that you think are necessary to your statements, and execute them against your COIN database.

Submitting your exercise

Enter your answers into the text box below. Click the Submit button to submit your answer.