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

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

Report message to a moderator

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.
Yes.
http://opreview.blogspot.com/2008/03/switching-between-plsql-java-and-shell.html
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.

Report message to a moderator

Previous Topic: Transforming Data During a Load (SQL*Loader) with SQL function
Next Topic: Field in data file exceeds maximum length
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Aug 15 14:30:25 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.