08-23-2012
It's a separate download from Oracle. You need to download the one which matches your Operating System.
This User Gave Thanks to methyl For This Post:
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
I want to input unix variable to sqlplus.The following is working fine
sqlplus username/password @dummy.sql param1 param2 << EOF
create user $1 identified by $2;
EOF
But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that??
Thanks... (3 Replies)
Discussion started by: sakthi.abdullah
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I am using a query like below in my shell script :
{
{
echo "set echo off"
echo "set head off"
echo "whenever sqlerror exit -1;
select NUMBER ||','||
FNAME ||','||
LOC ||','||
... (2 Replies)
Discussion started by: deepakgang
2 Replies
3. UNIX for Dummies Questions & Answers
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)
Discussion started by: Leo_NN
1 Replies
4. Shell Programming and Scripting
I am running a shell file following script on bash shell in solaris 10
(
echo abc@orcl
echo abc
echo "set feedback off"
echo "truncate table SIndexDataTypeHst1_changes;"
) | sqlplus -s
but getting the following error
ERROR:
ORA-01005: null password given; logon denied
... (3 Replies)
Discussion started by: mmunir
3 Replies
5. UNIX for Dummies Questions & Answers
Good day to everyone. This is my first time posting and just barely above basic Unix training. I think i have search thoroughly to ensure my question hasn't already been posted. But on the off chance the answer has been posted, please be nice as I am not 100% sure I know what I am looking for.
I... (1 Reply)
Discussion started by: Mrjester
1 Replies
6. Shell Programming and Scripting
Hi All,
Could anyoone please let me know how do I get sqlplus column header once in csv file
Scripts are below:
cat concreq.sh
#!/bin/bash
. $HOME/.profile
while ; do
sqlplus apps/pwd <<-EOF
set lines 100 pages 100
col "USER_CONCURRENT_QUEUE_NAME" format a40;
--set termout off... (5 Replies)
Discussion started by: a1_win
5 Replies
7. Shell Programming and Scripting
Hi Frndz,
I have req in which i need to run the query stored in some file and then store the resultset of the query in some other file.
PFB the code i have written:
#----Start job log---
SQLLOG='/opt/app/vertica2/cdr_dev/logs/conn_orac_db.log'
ORA_USER='abc'
ORA_PASSWD='xyz'
... (7 Replies)
Discussion started by: gnnsprapa
7 Replies
8. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
9. Programming
i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435
365765767
343534543
343543543
i want to pass this file to sqlplus
and sql command is
... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies
LEARN ABOUT OPENSOLARIS
download
download(1) User Commands download(1)
NAME
download - host resident PostScript font downloader
SYNOPSIS
download [-f] [-p printer] [-m name] [-H directory]
[file]...
/usr/lib/lp/postscript/download
DESCRIPTION
download prepends host resident fonts to files and writes the results on the standard output. If no files are specified, or if - is one of
the input files, the standard input is read. download assumes the input files make up a single PostScript job and that requested fonts can
be included at the start of each input file.
Requested fonts are named in a comment (marked with %%DocumentFonts:) in the input files. Available fonts are the ones listed in the map
table selected using the -m option.
The map table consists of fontname-file pairs. The fontname is the full name of the PostScript font, exactly as it would appear in a %%Doc-
umentFonts: comment. The file is the pathname of the host resident font. A file that begins with a / is used as is. Otherwise the pathname
is relative to the host font directory. Comments are introduced by % (as in PostScript) and extend to the end of the line.
The only candidates for downloading are fonts listed in the map table that point download to readable files. A font is downloaded once,
at most. Requests for unlisted fonts or inaccessible files are ignored. All requests are ignored if the map table can not be read.
OPTIONS
-f Force a complete scan of each input file. In the absence of an explicit comment pointing download to the end of the file,
the default scan stops immediately after the PostScript header comments.
-p printer Check the list of printer-resident fonts in /etc/lp/printers/printer/residentfonts before downloading.
-m name Use name as the font map table. A name that begins with / is the full pathname of the map table and is used as is. Other-
wise name is appended to the pathname of the host font directory.
-H directory Use dir as the host font directory. The default is /usr/lib/lp/postscript.
EXAMPLES
Example 1 Examples of the download command.
The following map table could be used to control the downloading of the Bookman font family:
%
% The first string is the full PostScript font name. The second string
% is the file name - relative to the host font directory unless it begins
% with a /.
%
Bookman-Light bookman/light
Bookman-LightItalic bookman/lightitalic
Bookman-Demi bookman/demi
Bookman-DemiItalic bookman/demiitalic
Using the file myprinter/map (in the default host font directory) as the map table, you could download fonts by issuing the following
command:
example% download -m myprinter/map file
EXIT STATUS
The following exit values are returned:
0 Successful completion.
non-zero An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWpsf |
+-----------------------------+-----------------------------+
SEE ALSO
dpost(1), postdaisy(1), postdmd(1), postio(1), postmd(1), postprint(1), posttek(1), attributes(5)
NOTES
The download program should be part of a more general program.
download does not look for %%PageFonts: comments and there is no way to force multiple downloads of a particular font.
Using full pathnames in either map tables or the names of map tables is not recommended.
SunOS 5.11 9 Sep 1996 download(1)