Loading data...

[Richard S. Crawford]

I am having problems loading data into my Oracle 9i database. I've
tried using SQL Loader but it looks like all of the possible field
delimiters that could be used -- !, |, ~, ^, etc. -- are already in use
in some text field or another in my database.

Am I SOL with this?

[Ana C. Dent]

Richard S. Crawford wrote:
I am having problems loading data into my Oracle 9i database. I've tried using SQL Loader but it looks like all of the possible field delimiters that could be used -- !, |, ~, ^, etc. -- are already in use in some text field or another in my database. Am I SOL with this?

Not necessarily.
What delimiter character is used in the input file to separate fields?
Can you make the fields fixed length in size?
It should not be too difficult to write some PERL code to load the data
into some staging tables.

HTH & YMMV

[Daniel Morgan]

Richard S. Crawford wrote:
I am having problems loading data into my Oracle 9i database. I've tried using SQL Loader but it looks like all of the possible field delimiters that could be used -- !, |, ~, ^, etc. -- are already in use in some text field or another in my database. Am I SOL with this?

If so ... how does a human being tell which ones are delmiters and which
are not?

Blow the entire record, unparsed, into a single VARCHAR2 column and
then write a proc to distribute it from there.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Noel]

> > I am having problems loading data into my Oracle 9i database. I've tried using SQL Loader but it looks like all of the possible field delimiters that could be used -- !, |, ~, ^, etc. -- are already in use in some text field or another in my database. Am I SOL with this? If so ... how does a human being tell which ones are delmiters and which are not?

Why don't help a human being?
We need to find a character which doesn't exist in data file.

Could be it:
CHR(63), CHR(96), CHR(128) - CHR(159)

FIELDS TERMINATED BY '?'

select ascii( '?') from dual;
--
63
--
TomekB

[Michael Austin]

Richard S. Crawford wrote:
I am having problems loading data into my Oracle 9i database. I've tried using SQL Loader but it looks like all of the possible field delimiters that could be used -- !, |, ~, ^, etc. -- are already in use in some text field or another in my database.

But, if you edit this file, what is the delimiter in "THIS" datafile??
Are "all" of these characters a part of the data (and not a delimiter)
in the datafile you want to load? It does not matter if it exists in
your database, the question is "does it exist in this datafile?

Do you have an example of the data (if not classified sensitive)...?

M.Austin Am I SOL with this?