Differenct between Load and Insert in Oracle
Posted: Fri Sep 05, 2008 7:39 am
Hi
I am facing problem with Load option while loading from source table(oracle 10g) to target table (oracle9i). I have selected write method as load & truncate. In this situation job got aborted and returned the error sqldr 256. But the same job tried with insert option. The job was successfully executed and loaded the data.
Thanks
Suresh
I am facing problem with Load option while loading from source table(oracle 10g) to target table (oracle9i). I have selected write method as load & truncate. In this situation job got aborted and returned the error sqldr 256. But the same job tried with insert option. The job was successfully executed and loaded the data.
Thanks
Suresh