How to Use the Default Local Rollback Segment
- 1). Click the "Start" menu, and click "All Programs" to select this option. Click the folder "Oracle - OraHome."
- 2). Click "Application Development," and click "SQL Plus."
- 3). Type your user name and password to log in. Contact your tech support immediately if you do not know your login credentials.
- 4). Type (without the quotes) "CREATE TABLESPACE tbspace," thenpress the "Enter" key. Replace "tbspace" with a name for your tablespace.
- 5). Type (without the quotes) "CREATE ROLLBACK SEGMENT rlbks TABLESPACE tbspace," then press the "Enter" key. Replace "rlbks" with a name for your default rollback segment. Replace "tbspace" with the name of the tablespace you created in the previous step.
- 6). Type (without the quotes) "ROLLBACK SEGMENT rlbks," then press the "Enter" key. Replace "rlbks" with the name of your default rollback segment from the previous step.
