RE: $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr

That's what we do too.
This is the command to do it:

ln -sn $ORACLE_HOME/bin/sqlldr $ORACLE_HOME/bin/sqlload

-----Original Message-----
Sent: Monday, July 09, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L

Ken,

   Earlier versions had sqlldr and sqlload as copies of the same code. I think sqlload was a link in 8.0.x. Now with 8i it's gone. You can create the link if you do not wish to change the existing code. We did just that since Developers did not want to change their scripts.

HTH, Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Fowler, Kenneth R [SMTP:kenneth_r_fowler_at_groton.pfizer.com]
> Sent: Monday, July 09, 2001 11:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr
>
> List,
>
> I am currently working on migrating an application from Oracle 7.3 to
> Oracle
> 8.1.6.2 (This is on Solaris 2.6). One of the shell scripts makes use of
> sqlload ($ORACLE_HOME/bin/sqlload) which exists on the 7.3 server but not
> on
> the 8.1.6.2 server. On the 7.3 server it looks like there are two
> directory
> entries, one for sqlload and one for sqlldr...
>
> orapps1 $ ls -al | grep sql
> -rwxr-x--x 2 oracle dba 3612900 Oct 3 1997 sqlldr
> -rwxr-x--x 2 oracle dba 3612900 Oct 3 1997 sqlload
>
> On the 8.1.6.2 server there is just sqlldr. I am wondering if the sqlload
> link is something that has been dropped from newer versions? or has
> someone
> manually applied the link to the 7.3 server?
>
> Thanks,
> Ken
> _________________________________________
> Clinical and Regulatory Informatics - Groton/New London
> Coordinator, Business and Technical Services
> Tel: (860) 732-0026 Fax: (860) 715-8346
> Email: mailto:fowlerkr_at_groton.pfizer.com
>
>
>
> LEGAL NOTICE
> Unless expressly stated otherwise, this message is confidential and may be
> privileged. It is intended for the addressee(s) only. Access to this
> E-mail by anyone else is unauthorized. If you are not an addressee, any
> disclosure or copying of the contents of this E-mail or any action taken
> (or not taken) in reliance on it is unauthorized and may be unlawful. If
> you are not an addressee, please inform the sender immediately.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fowler, Kenneth R
> INET: kenneth_r_fowler_at_groton.pfizer.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).