Truncate the table before inserting into it.
Posted: Wed Jun 13, 2007 11:38 am
Hi all,
I have a scenario where I need to INSERT 17 Million records in a table
I need to truncate the table before inserting these records. i.e. before I insert these 17 Mi records I need to delete all the records from the target table.
I am using an Oracle enterprise stage. Is there a way in which I can truncate the whole table before I insert these records?
Thanks for the help.
I have a scenario where I need to INSERT 17 Million records in a table
I need to truncate the table before inserting these records. i.e. before I insert these 17 Mi records I need to delete all the records from the target table.
I am using an Oracle enterprise stage. Is there a way in which I can truncate the whole table before I insert these records?
Thanks for the help.