I have a sqlplus report and inside that report I have the following piece of code to mail the report output to the email id.
My requirement is, instead of emailing the output I want to FTP that script to a different unix server (say ip as 10.10.1.1). How to modify this code to FTP the spool file... (0 Replies)
HI
Have some problem with spooling out some relatively large number of records (~2-3 mil)
Small table - OK though.
Getting error: SP2 0308: cannot close spool file.
Any thoughts?
sqlplus -s user/pwd << EOF
set term off
set head off
set trims on
set pages 0
set... (1 Reply)
Wondering if anybody can help with changing the output of a field. I'm needing to change the output of a field in this file:
User Process ID Time Active Licences Type
ChangeAdmin (Phys-agsdev/19353 212), start Wed 1/21 6:30 (linger: 1800)
u414013 (Phys-agsdev/19353 1491), start Wed 1/21 12:54... (5 Replies)
Hi,
I'm creating a shell script to dynamically create a recreate controlfile for an Oracle database. I need to read a cold backup file system, and make some changes to these files.
Let's say for argument sake the directory name is /ebsprod_c/oradata and it looks like this:... (6 Replies)
I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible?
if yes just give me an example for doing that. (2 Replies)
Hello All,
I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below.
cat > $v_Input_File 2>>$v_Log << EOF
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16';
EXECUTE... (1 Reply)
Hello All,
I have exactly same issue @vikas_trl had in following link:
https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would... (4 Replies)
Hi,
I am new to shell script programming. I have written a ksh script to run the sql File placed in server directory and spool the output in destination directory.
Below Command:
$ORACLE_HOME/bin/sqlplus -s $ora_uid @$sqlfile_loc$testquery.sql > $opfiledirectory
It is generating the output... (6 Replies)
Hi,
I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop.
The first SQL file is basically a connection test and it is supposed to sort... (2 Replies)
Hello All,
Could you please help me if i am doing anything wrong in below script, especially the sqlplus part performance wise or anything else i could improvise in the script. Thank you.
#!/bin/ksh
## Batch Obj Id
MP_BCH_OBJ_ID=$1
PASS=$2
partition=$3
## script dir... (6 Replies)
Discussion started by: Ariean
6 Replies
LEARN ABOUT DEBIAN
qpid-python-test
qpid-python-test(1) User Commands qpid-python-test(1)NAME
qpid-python-test - run tests of the python QPID library for a broker
SYNOPSIS
qpid-python-test [options] PATTERN ...
DESCRIPTION
Run tests matching the specified PATTERNs.
OPTIONS -h, --help
show this help message and exit
-l, --list
list tests instead of executing them
-b BROKER, --broker=BROKER
run tests against BROKER (default localhost)
-f FILE, --log-file=FILE
log output to FILE
-v LEVEL, --log-level=LEVEL
only display log messages of LEVEL or higher severity: DEBUG, WARN, ERROR (default WARN)
-c CATEGORY, --log-category=CATEGORY
log only categories matching CATEGORY pattern
-m MODULES, --module=MODULES
add module to test search path
-i IGNORE, --ignore=IGNORE
ignore tests matching IGNORE pattern
-I IFILE, --ignore-file=IFILE
ignore tests matching patterns in IFILE
-H, --halt-on-error
halt if an error is encountered
-t, --time
report timing information on test run
-D DEFINE, --define=DEFINE
define test parameters
SEE ALSO
For more information on qpid-python-test please check the QPID wiki at http://qpid.apache.org.
Apache QPID October 2011 qpid-python-test(1)