| Oracle RDB Loader question [message #184718] |
Thu, 27 July 2006 09:44  |
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
|
Member |
|
|
I'm currently using an oracle rdb database on a openvms system. My question is: can I use loader to update records or does loader is just used to insert records ?
I have to perfom a load in wich some records should be inserted and some just updated. Any Suggestion ?
thanks in advance
|
|
|
|
| Re: Oracle RDB Loader question [message #184738 is a reply to message #184718] |
Thu, 27 July 2006 11:43  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
SQL*Loader only inserts data into from a file into Oracle table (can, though, REPLACE or APPEND records into it) - update isn't possible.
But, if you run Oracle 9i or higher on your OpenVMS, you might use external tables feature which would then enable you to use operating system file as if it was ordinary Oracle table; doing so, you'd be able to distinguish records and, through PL/SQL code, insert record or update existing ones.
If your Oracle version is lower than 9i, you could load the whole file into a temporary table and then perform the same PL/SQL action as mentioned earlier.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
