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.