Urgent: SQL*Loader Question

From: <premal_shah_at_my-deja.com>
Date: Sat, 31 Jul 1999 10:06:43 GMT
Message-ID: <7nuhrh$vl3$1@nnrp1.deja.com>

Hi! Folks:

How do I get SQL*Loader to preserve my trailing and beginning whitepace for CHAR fields. I read the documentation and they mentioned using the PRESERVE BLANKS keyword in the control file when I am specifiying the FIELDS TERMINATED BY... line.

I tried that and SQL*Loader is giving me a syntax error.

Can you please give me a small example of a control file with this keyword? I saw the examples in the documentation and could not find anything.

We are running Oracle 8.0.5.1 on Solaris 2.6.

Thanks a lot for your time and help.

regards,
premal

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 31 1999 - 05:06:43 CDT