Truncate and load oracle table

getsatish_gk · Post by **getsatish_gk** » Mon Jun 30, 2008 9:59 pm

I want to truncate the oracle table and load it. but i could not find this option at oracle enterprise edition stage.

Does any one know who do truncate and load the oracle table?

Thanks in adv
Satish

martind · Post by **martind** » Mon Jun 30, 2008 10:13 pm

Set the Write Mode dropdown box to 'Truncate' in the Target on the Properties tab on the Oracle stage.

getsatish_gk · Post by **getsatish_gk** » Mon Jun 30, 2008 10:18 pm

I know this will only truncate the table. but what about data load after that?

but i want perform in one go.

-regards,
Satish

martind · Post by **martind** » Mon Jun 30, 2008 10:47 pm

This option will truncate and then append the new rows.

keshav0307 · Post by **keshav0307** » Mon Jun 30, 2008 10:53 pm

I know this will only truncate the table. but what about data load after that?

is it your assumption or it is written some where?