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 ULTRIX
uurespool
uuaids(8c)uuaids(8c)Name
uucompact, uumkspool, uurespool, uupoll - uucp utilities
Syntax
uucompact -ssystem
uumkspool system ...
uurespool [ -t# ]
uupoll system ...
Description
All of the commands are located in
The command compacts uucp system spool directories and associated subdirectories. If system is ALL, then all existing uucp system spool
directories are compacted. Otherwise, only the specified system spool directory is compacted. If no system is specified, is compacted.
If is stopped before it is finished, it can be restarted without reprocessing directories. The command continues processing where it left
off during it's previous instantiation.
The command makes a per system spool directory and associated subdirectories for each of the specified systems. For example, if system is
mk3 and if the local system name is penny, the following directories are created:
/usr/spool/uucp/sys/mk3
/usr/spool/uucp/sys/mk3/C.
/usr/spool/uucp/sys/mk3/X.
/usr/spool/uucp/sys/mk3/D.
/usr/spool/uucp/sys/mk3/D.penny
/usr/spool/uucp/sys/mk3/D.penny
The command moves files from old spool directories to new spool directories. Because the structure of the spool directories has changed
from older versions of it is necessary to respool old spooled files to new spool directories in at least two instances:
o When installing the current version of
o When creating a new system spool directory for each system.
In the latter case, it is necessary to move files from to the new spool directories. To ease this task, moves files that have been spooled
in one of 4 formats and respools them under the new spooling structure. The format is specified by the -t# option, where the number sign
(#) can be any one of the following:
o Original spool - All files are in
o Split spool - Contains the subdirectories
o Modified split spool - Contains all subdirectories listed in split spool, and
o Used when a new system directory has been created and spool files must be moved from the DEFAULT directory to the new system directory.
The command forces a connect attempt to the named systems even if recent attempts have failed, but not if the file prohibits the call. For
example, the file will prohibit the call if it is the wrong time of day. Thus, the should be monitored for messages about the connection.
Files
Spool directory
Logfile
See Alsomail(1), uucp(1c), uux(1c)uuaids(8c)