07-21-2006
Shell Script for Data loading in Oracle
Hi All
I am new to unix.
I need a shell script to load a datafile in to oracle.
I already have a control file, and data file. all I need is if i execute the shell it must load the data using the ctl file to table.
Control file : PAY0001.ctl
Datafile : mon_grs_det.dat
log file : mon_gross_det.log
discard_file: mon_gross_det.dis
i will be calling the shell from Appworx Scheduler
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database.
Requirement:-
1. Need to connect to Oracle database from Unix Shell script.
2. Need to pick Text file from some location on Unix Box.
3. Need to upload the data from text file to... (6 Replies)
Discussion started by: chandrashekharj
6 Replies
2. Shell Programming and Scripting
Like class loader in java, can we make a function loader in shell script, for this can someone throw some light on how internally bash runs a shell script , what happenes in runtime ...
thanks in advance.. (1 Reply)
Discussion started by: mpsc_sela
1 Replies
3. Shell Programming and Scripting
shell script (4 Replies)
Discussion started by: frns5
4 Replies
4. Shell Programming and Scripting
Hi All,
I am trying to load a data from a files in a particular directory to a database..
cd $SCC
isql metdb >> ${LOGDATA}/LOAD.LOG < !
load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE
!
But it's showing the error "syntax error at line 46 : `<<' unmatched"
Can u plz help me... (5 Replies)
Discussion started by: grajesh_955
5 Replies
5. Shell Programming and Scripting
Hi
I would like to know how to load oracle data to unix flat file using a shell script.
Can we use sqlldr to import data from oracle, if so can anyone help me with it. (2 Replies)
Discussion started by: raghav288
2 Replies
6. UNIX for Advanced & Expert Users
asdfasdfasdfasdf??? (2 Replies)
Discussion started by: noorm
2 Replies
7. Shell Programming and Scripting
Hi,
How to fetch data from oracle database in unix shell scripting.
list=`sqlplus -s ds_user/dsuser@EMI <<EOF
set feedback off
set serveroutput on
set heading off
set pagesize 0
set tab off
select IP_ID from table
/
exit
EOF`
The output is not what i expected.I need output in... (4 Replies)
Discussion started by: Anusha_Reddy
4 Replies
8. Shell Programming and Scripting
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies
9. Shell Programming and Scripting
Hello everyone,
I am new to shell scripting/ loading data into a database.
I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies
10. Shell Programming and Scripting
Hi ,
I have a scenario, i have a directory where i receive around 14-15 files at a interval of 20-40 min not fixed, i want to write a unix scripts which invoke sqlldr command to load files into oracle automatically as soon as the file hit the directory.
Any help will be appreciated.
... (4 Replies)
Discussion started by: guddu_12
4 Replies
LEARN ABOUT DEBIAN
rpld-prev
rpld-*(1) System User's Manual: rpld-deprecated rpld-*(1)
NAME
rpld-deprecated - Deprecated RoarAudio PlayList Daemon control programs
SYNOPSIS
rpld-play
rpld-stop
rpld-next [--ifcurple PLE]
rpld-prev
rpld-addplaylist PLI
rpld-delplaylist PLI
rpld-store
DESCRIPTION
The RoarAudio PlayList Daemon is a daemon which manages playlists and can play files or streams from those lists using a RoarAudio Sound
Server.
This is a set of deprecated tools to do simple control of the server. All those tools has be replaced by rpld-ctl(1).
The following tools are deprecated:
rpld-play
Start playback if not yet started.
Replaced by: rpld-ctl play
rpld-stop
Stop playback.
Replaced by: rpld-ctl stop
rpld-next [--ifcurple PLE]
Skip current song.
if --ifcurple and a PLE is given the song is only skiped if the currently played song matches the given PLE.
This tool has only been deprecated in case --ifcurple is not used. Replaced by: rpld-ctl next
rpld-prev
Go back to previous song.
Replaced by: rpld-ctl prev
rpld-addplaylist PLI
Add playlist with name PLI.
Replaced by: rpld-ctl addplaylist PLI
rpld-delplaylist PLI
Delete playlist PLI.
Replaced by: rpld-ctl delplaylist PLI
rpld-store
Store current state to disk.
This tool should not be needed to be called by a user at all for normal use cases.
Replaced by: rpld-ctl store
SEE ALSO
rpld-tools(1), rpld(7), RoarAudio(7).
HISTORY
For history information see RoarAudio(7).
rpld-deprecated May 2012 rpld-*(1)