What is the right syntax/hint for direct path insert?
I tried all these...and they all worked.
1. insert /*+ append */
2. insert /* + append */
3. insert /**+append **/
4. insert /**++apend **/
There seems no error for coding the hint
How do i know if my direct path insert really is direct?
the first one - check how much redo you are generating to see if it is working for you
or you could do ...
... I believe, but I prefer the /*+ append */ notation myself.
insert --+ append
Yes, no error is raised if a hint is malformed, even such as ...
... the hint is just treated as a comment.
insert /*+ apend */ into
Click Here to Expand Forum to Full Width