Name

DROP ROLLBACK SEGMENT

Synopsis

DROP ROLLBACK SEGMENT segment_name

Removes a rollback segment (segment_name) from the database.

Notes

You must have the DROP ROLLBACK SEGMENT privilege to issue this command. The rollback segment must be taken offline using the ALTER ROLLBACK SEGMENT command before it can be dropped. When it is dropped, all space used by the rollback segment is returned to the free space pool.

Example

The following example removes the rollback segment RBS02 from the database:

DROP ROLLBACK SEGMENT RBS02
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset