Inserting data into nested tables in oracle 10g

loe_ram13 · Post by **loe_ram13** » 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

ray.wurlod · Post by **ray.wurlod** » Mon May 19, 2008 10:49 pm

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

loe_ram13 · Post by **loe_ram13** » 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?

Rubu · Post by **Rubu** » 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.