simple question,
If we put
SQL>set autocommit on
does it mean rollback segment won't be used?
does it commit just after insert/delete/update statement?
thanks
_____________________________________________
Why on earth OCP is to be proud.
Printable View
simple question,
If we put
SQL>set autocommit on
does it mean rollback segment won't be used?
does it commit just after insert/delete/update statement?
thanks
_____________________________________________
Why on earth OCP is to be proud.
NoQuote:
does it mean rollback segment won't be used?
According to the documentation, yes. However DDL statements have an implicit commit. This includes TRUNCATE.Quote:
does it commit just after insert/delete/update statement?
thanks slimdave, meaning set autocommit on can be used for batch data loading where rollback segment/undo tbs will be used only for single transaction(cause it commit just after every single DML ). is that correct?
I suppose so, but personally i never use it. I prefer issuing commits explicitly, as I think it aids supportability, and there's too many cases where i want multiple statements to commit or rollback together.
With External Tables available in 9i, I don't have a lot of use for SQL*Plus-based scripts -- I tend do do them in PL/SQL and schedule with DBMS_JOB.