I am trying to load a large database into Oracle 7.3.3. I am planning to
use SQL*Loader. I have a column of hexadecimal data that I want to load as
integer data. This column will be used as the primary key, and I believe
Oracle will more efficiently index the table if it treats this column as
numerical rather than character data.
Question: Is there an elegant way to convert the hex to decimal during
the sqlload? Another option would be to process the datafile first using a
shell script, and then load it into Oracle.
Please send help to the email address below.
--John-Paul Mead
+------------------------------------------------------------------+
| John-Paul D. Mead home : (718) 596-2357 |
| Class of 1998 beep : (917) 953-5777 |
| NYU School of Medicine work : (212) 263-5744 |
| |
| mailto:meadj01_at_popmail.med.nyu.edu |
| http://shamrock.med.nyu.edu/~meadj01 |
| |
| PGP Key at: http://shamrock.med.nyu.edu/~meadj01/pgp.html |
+------------------------------------------------------------------+
Received on Wed Sep 10 1997 - 00:00:00 CDT
