-
autocommit
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.
-
does it mean rollback segment won't be used?
No
does it commit just after insert/delete/update statement?
According to the documentation, yes. However DDL statements have an implicit commit. This includes TRUNCATE.
-
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.
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
|