10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
2. Homework & Coursework Questions
Hi,
I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script.
The table has two columns - Acct_number (not nullable) and date (timestamp).
I'm not able to write a shell script for that. Can any one help me?
... (3 Replies)
Discussion started by: saisudeep
3 Replies
3. Shell Programming and Scripting
Hi Gurus,
I am new to this unix world...I need your help to walk through.
I want to learn shell scripting..... The shell script which can be able to use with oracle pl/sql...
So please suggest me which shell is good.
Which Unix/Linux version is good for this to Install to get practice the... (8 Replies)
Discussion started by: GaneshAnanth
8 Replies
4. UNIX for Advanced & Expert Users
Hi,
I have basic knowledge on how to write pl/sql code inside shell script.
I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script.
Please help
Thanks!!!!!! (1 Reply)
Discussion started by: diehard
1 Replies
5. Shell Programming and Scripting
Hi, can anyone help me with this script please. I need the oracle command to go into the unix batch file.
#!/bin/sh
# A menu driven Shell script which has following options
# for acmtoron@>
#
#
# Exit
# As per option do the job
#----
while :
do
clear
echo " A C M LOG MONITORING... (0 Replies)
Discussion started by: tinaaguilera
0 Replies
6. UNIX for Dummies Questions & Answers
I am new in unix..
I am running a sql loader script where I have to specify the data file path but the file name contains spaces in it
so giving error multiple arguments
I have tried it with "" and '' but does n't work the command is :
$ORACLE_HOME/bin/sqlldr... (1 Reply)
Discussion started by: Sandip Dey
1 Replies
7. UNIX for Advanced & Expert Users
Hello All,
I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script.
I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable).
But, what if we want to return multiple values?
One option I... (4 Replies)
Discussion started by: bright_future
4 Replies
8. Shell Programming and Scripting
Here's a shell script snippet.....
cd $ORACLE_HOME/bin
Retval=`sqlplus -s <<eof
$TPDB_USER/april@$TPD_DBCONN
whenever SQLERROR exit 2 rollback
whenever OSERROR exit 3 rollback
set serveroutput on
set pages 999
var status_desc char(200)
var status_code... (1 Reply)
Discussion started by: hidnana
1 Replies
9. Shell Programming and Scripting
Hi Guys,
I am looking to develop a SQL Loader script that would bascially allow the user to have a txt file (or such) as an input file containing .sql scripts procedures, triggers, bascially anything against a database that could then be run automatically.
Let me break it down a bit more,... (2 Replies)
Discussion started by: LiquidChild
2 Replies
10. Shell Programming and Scripting
Hi,
I have a shell script where I log on to sqlplus like this
log()
{
sqlplus -s scott/tiger <<!
select count(*) from EMP;
!
}
log
Here I have hardcoded/used the username : scott and password : tiger directly to log on to SQLPLUS. If i have my log in information in my profile file... (2 Replies)
Discussion started by: manirsendhil
2 Replies
sadc(8) BSD System Manager's Manual sadc(8)
NAME
sadc -- system activity data collector
SYNOPSIS
/usr/lib/sa/sadc [-m mode] [t n] [ofile]
DESCRIPTION
The sadc tool is used to collect cumulative system activity data. The sample system data is collected at intervals t seconds apart, in a
loop n times. The binary sample data is written to ofile if specified. Otherwise, the binary data is written to stdout. If the ofile file
does not exist, it is created, otherwise it is truncated.
sadc is intended to be used as the engine behind the sar(1) command, and is not typically invoked on the command line. Two shell scripts,
sa1 and sa2 are provided to drive the typical sampling, saving, and reporting process.
OPTIONS
The following options modify the way data is collected by sadc.
-m mode Modify the collection of system statistics as specified by mode. Currently only one mode is supported.
PPP By default, the collection of ppp network interface statistics is turned off. This is because the number of ppp connec-
tions can be very high, causing the raw data file to grow unexpectedly large, especially when samples are collected at
short intervals. Use the PPP mode to turn the collection back on.
EXAMPLES
/usr/lib/sa/sadc 15 20 /tmp/sample.out
This call collects 20 samples at 15 second intervals. The binary data is written to the /tmp/sample.out file
FILES
/var/log/sa/sadd Default daily activity file that holds the binary sampling data. dd are digits that represent the day of the month.
/usr/lib/sa/sa1 Shell script used to drive the sar data collection.
/usr/lib/sa/sa2 Shell script used to drive the sar data reporting.
SEE ALSO
sa1(8), sa2(8), sar(1), iostat(8), vm_stat(1), netstat(1), top(1), sc_usage(1), fs_usage(1)
Mac OS X Jul 25 2003 Mac OS X
03-20-2007
Shell script for accessing a file in the network drive and invoking oracle sql loader