| Bulk load question [message #74309] |
Tue, 09 November 2004 08:33  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
