Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Use set rollback segment in PL/SQL (Read 4050 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Use set rollback segment in PL/SQL
15.08.06 at 13:23:53
 
Use set rollback segment in PL/SQL
 
When you need to specify to use a specific rollback segment in Oracle you cannot use the SQL*Plus statement: set rollback statement 'rs_big'.
In PL/SQL you can use the package dbms_transaction:
 
DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT('rs_big');
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1