Yes, but what if next time you execute the SQL, it uses a different rollback segment (like R04)?
If you create a BIG rollback segment, you can force it's use by one of the following:
Code:
SET TRANSACTION USE ROLLBACK SEGMENT RBIG;
-- Or within a PL/SQL Block:
...
DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT(RBIG);
...
Note: The "SET TRANSACTION" must follow a "COMMIT;" and precede the Statement to use the specified rollback segment.
----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Or you can use the COMMIT=Y import option (parameter).
----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.