|
-
CREATE ROLLBACK SEGMENT BIG_RBS STORAGE(INITIAL 1M NEXT 1M OPTIMAL 1M MINEXTENTS 2);
ALTER ROLLBACK SEGMENT BIG_RBS ONLINE;
**drop indexes on the delete table if appropriate**
COMMIT;
SET TRANSACTION USE ROLLBACK SEGMENT BIG_RBS;
DELETE FROM ******** WHERE **********;
ALTER ROLLBACK SEGMENT BIG_RBS SHRINK;
ALTER ROLLBACK SEGMENT BIG_RBS OFFLINE;
John Doyle
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|