Home » RDBMS Server » Server Utilities » unix command from oracle (oracle sun solaris 10.5)
unix command from oracle [message #600928] Thu, 14 November 2013 02:07 Go to next message
Messages: 223
Registered: April 2012
Location: UK
Senior Member

i load data from file to oracle through unix file system. file comes with ^mcharacter and to remove it we use dos2unix.
my load start whenever file arrive in director automatically so i want a system which can do dos2unix before running them. is there anyway we can run unix command from oracle interface.

please help
Re: unix command from oracle [message #600955 is a reply to message #600928] Thu, 14 November 2013 03:53 Go to previous message
Mahesh Rajendran
Messages: 10704
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> is there anyway we can run unix command from oracle interface.
Though a little old, above article still holds good for the basics.

And in most cases, you actually need the other way around which is way simple.
Write a shell script to employ dos2unix and then load the data using oracle tools.
Previous Topic: Transforming Data During a Load (SQL*Loader) with SQL function
Next Topic: Field in data file exceeds maximum length
Goto Forum:

Current Time: Mon Aug 15 14:30:25 CDT 2022