RE: RE: SQL*Loader

Just a thought: What about adding a dummy CHAR(1) field (See VARCHAR(1) vs. CHAR(1) storage requirements thread!) to the Oracle table and a NULLIF qualifier to it's corresponding SQL*Loader input so that the field is kinda ignored?

Or, check out http://www.cpan.org and download Perl for Winders. :)

I dunno if it's possible for you, but one of these ideas has to work and be better than writing some Pro*C!

Good luck! :)

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             QTI -- Sussex, WI USA

> -----Original Message-----
> From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
> Sent: Friday, June 30, 2000 17:24
> To: Multiple recipients of list ORACLE-L
> Subject: Re:RE: SQL*Loader
>
>
> Eric,
>
> Yeah I could drop the column if we were using 8i, but
> were on 8.0 still.
> Also this "file" gets created, loaded, recreated, reloaded,
> etc... several
> thousands of times a day. Also have a requirement for no
> operator intervention,
> variable number of records in file, and must run in
> background while tester gets
> on with it's life. Looks like a Pro*C solution is all that's left.
>
> Dick Goulet

This message has been scanned for viruses with Trend Micro's Interscan VirusWall. Received on Fri Jun 30 2000 - 16:53:44 CDT