-
direct-path insert
Hi,
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 :confused:
How do i know if my direct path insert really is direct?
Thanks
-
the first one - check how much redo you are generating to see if it is working for you
-
or you could do ...
Code:
insert --+ append
into ...
... I believe, but I prefer the /*+ append */ notation myself.
Yes, no error is raised if a hint is malformed, even such as ...
Code:
insert /*+ apend */ into
... the hint is just treated as a comment.