Friday, December 28, 2012

Useful points about Oracle APPEND Hint



Some points to keep in mind while using APPEND hint in ORACLE:

I am listing down some points that I came across and had to consider while using an APPEND hint.  This might not be a complete list - just throwing out which I think are useful.   

It does a direct path insert
Adds rows above high water mark
Parallel hint is always a direct path, if you go parallel, you will be appending.
Insert /*+ append */ will ignore the append hint and use conventional path loading when the table has referential integrity or a trigger.
Only one session can do a direct path load on a table, no other session can do direct path on the same table.  Also no other session could also issue insert, update or delete statements on this table.

Feel free to add more points in the comments section...

No comments:

Post a Comment

Convert Java SQL String to Oracle SQL Format in TOAD

At times Toad might reset the capability to strip off / convert the the SQL in Java string format to SQL format. You can have that back...