DSXchange

Posted: **Mon May 19, 2008 10:30 pm**

Require help in inserting data into a nested table in oracle 10g database through datastage.
Thanks in advance

Posted: **Mon May 19, 2008 10:49 pm**

EXACTLY the same way you would do it in sqlplus or TOAD.

Posted: **Mon May 19, 2008 10:57 pm**

ray.wurlod wrote:EXACTLY the same way you would do it in sqlplus or TOAD. ...

Can i do that using sqlldr and setting DIRECT=TRUE option for fast load?

Posted: **Mon May 19, 2008 11:12 pm**

Never worked with Oracle..but read somewhere that Oracle Load stage uses sqlloader with DIRECT=TRUE by default.

Inserting data into nested tables in oracle 10g