Home » RDBMS Server » Server Utilities » sql*loader lookup values
sql*loader lookup values [message #147190] Wed, 16 November 2005 04:00 Go to next message
ariel_gronau
Messages: 2
Registered: November 2005
Junior Member
Hi,
We need to load some external URNs into a table using sql*loader, but we need to translate those values to other ones using a lookup table we have within the DB.
Is it possible to somehow join the external data to this lookup table and insert into the final table the translated values?

Cheers,

A.

Report message to a moderator

Re: sql*loader lookup values [message #147210 is a reply to message #147190] Wed, 16 November 2005 06:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what is URN?
You can make use of what we call external tables.
External tables allow you to consider an external flat file (text file) as an oracle table.
Please rephrase the question with oracle versions and OS versions.

Report message to a moderator

Re: sql*loader lookup values [message #147220 is a reply to message #147210] Wed, 16 November 2005 07:54 Go to previous messageGo to next message
ariel_gronau
Messages: 2
Registered: November 2005
Junior Member
Sorry about being unclear.

By a URN (Unique Reference Number) i just mean a unique id.
We are using oracle 9.2.

thanks.

Report message to a moderator

Re: sql*loader lookup values [message #147258 is a reply to message #147220] Wed, 16 November 2005 18:41 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Do what Mahesh said: look into Externally Organized Tables. Search this forum for heaps of advice.

_____________
Ross Leishman

Report message to a moderator

Previous Topic: Imort data to Database
Next Topic: Any way to import an external database without Oracle Utilties such as Import?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 03 23:09:49 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.