direct-path insert

[yxez]

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
How do i know if my direct path insert really is direct?

Thanks

[davey23uk]

the first one - check how much redo you are generating to see if it is working for you

[slimdave]

or you could do ...

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 ...

insert /*+ apend */ into

... the hint is just treated as a comment.