Bulk load question [message #74309] |
Tue, 09 November 2004 08:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jdba
Messages: 3 Registered: November 2004
|
Junior Member |
|
|
Gurus,
There is a third party software called Informatica which is bringing data in our Oracle database using Bulk Load. I am assuming that this process is not very different than SqL LOADER bulk load process.
Do we need to take backups of our database once this happens ?
Thanks
|
|
|
Re: Bulk load question [message #74314 is a reply to message #74309] |
Wed, 10 November 2004 07:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
There should be no need to take backups. Treat it like any other transaction. Don't get confused between DIRECT loads and BULK operations, DIRECT loads bypass the SQL engine and write straight to the file (I think) and BULK operations are set based DML.
|
|
|