sqlplus default script directory

massimo874

Please some one can tell me wich is the SQLPlus default script directory an
how I can set it.
I tryed by 'Define' but SQLPlus don't find the scripts I give it in input.

WinXP, ORACLE 9i.

Jul 19 '05 #1

Subscribe Post Reply

19375

Douglas Hawthorne

"massimo874" <massimo874@_SPAMMATUAMAMMA_inwind.it.invalid> wrote in message
news:A1*******************@tornado.fastwebnet.it.. .

Please some one can tell me wich is the SQLPlus default script directory an how I can set it.
I tryed by 'Define' but SQLPlus don't find the scripts I give it in input.

WinXP, ORACLE 9i.

See p.A-2 of the "Oracle 9i Windows SQL*Plus Getting Started" manual.
(A92157-01)

The default SQLPlus directory is %ORACLE_HOME%\dbs

The following method works as well:
Open 'CONTROL PANEL'
Open 'System'
Select 'Advanced' tab
Click on 'Environment Variables'
Click on 'New' under 'System Variables'
Variable Name is 'SQLPATH' and the value is a list of directories separated
by semicolons ';'.

Douglas Hawthorne

Jul 19 '05 #2

massimo874

thank you

"Douglas Hawthorne" <do**************@yahoo.com.au> ha scritto nel messaggio
news:wz****************@news-server.bigpond.net.au...

"massimo874" <massimo874@_SPAMMATUAMAMMA_inwind.it.invalid> wrote in message news:A1*******************@tornado.fastwebnet.it.. .
Please some one can tell me wich is the SQLPlus default script directory an
how I can set it.
I tryed by 'Define' but SQLPlus don't find the scripts I give it in input.
WinXP, ORACLE 9i.

See p.A-2 of the "Oracle 9i Windows SQL*Plus Getting Started" manual.
(A92157-01)

The default SQLPlus directory is %ORACLE_HOME%\dbs

The following method works as well:
Open 'CONTROL PANEL'
Open 'System'
Select 'Advanced' tab
Click on 'Environment Variables'
Click on 'New' under 'System Variables'
Variable Name is 'SQLPATH' and the value is a list of directories

separated by semicolons ';'.

Douglas Hawthorne

Jul 19 '05 #3

by: Rick | last post by:

I am installing Oracle 9i client runtime on AIX 5.1-003. The installation completes successfully, but neither the Net Configuration Assistant or SQLPLUS will run. I get the following error when...

Oracle Database

SQLPLUS command line question

by: tommy | last post by:

I'm running sqlplus from a DOS command line and inducing an error by purposly giving it the wrong script (hence, it cannot find the script file.) What it is doing is exiting to the SQL> prompt as...

Oracle Database

Inconsistent behaviour creating java stored objects using sqlplus in Oracle 8i

by: Matt | last post by:

I'm new to Java but experienced with PL/SQL. I've found what appears to be strange behaviour (a bug?) when attempting to create java stored objects using the UNIX version of Oracle SQL*PLUS...

Oracle Database

How to return a status from sqlplus to .ksh unix script ?

by: Zvika Glickman | last post by:

I have a script a.ksh as follow: <orasp> cat a.ksh sqlplus -s rsi/rsi < aaa1.sql echo stat $? <orasp> text of aaa1.sql: exec dbms_stats.gather_table_stats

Oracle Database

problem in compiling with sqlplus.hh

by: tyousaf | last post by:

Hi i am new to mysql and mysql++, i have installed mysql server, it is running fine. i also installed "mysql++-1.7.9gcc3.2-2.i386.rpm" (i have gcc 3.3) , first of all as the readme file says to do...

MySQL Database

sqlplus exit statement prematurely terminates unix script

by: tngoe | last post by:

#!/bin/ksh echo "" echo "Enter person ID:" read person_id sqlplus -silent '/nolog'<<end_sql1 connect useract/passwd start $BANNER_LINKS/gurlsid.sql $person_id FAISMGR end_sql1

Linux

how do you display the name of a SQLPLUS script that is running

by: edwardscm | last post by:

Like in UNIX where you can echo $0 and it gives the name of the script running how do you do a similar thing in SQLPLUS. Is there a set option that can be turned on that will allow the name of the...

Oracle Database

sqlplus default script directory

by: massimo874 | last post by:

Please some one can tell me wich is the SQLPlus default script directory an how I can set it. I tryed by 'Define' but SQLPlus don't find the scripts I give it in input. WinXP, ORACLE 9i.

Oracle Database

pasted sqlplus script no longer running

by: draffe | last post by:

This is not a sqlplus script problem per se but I don't know where else to go with my problem. I use wordpad to record my sqlplus script, then copy and paste it into the sqlplus prompt. I've run...

Oracle Database

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

sqlplus default script directory

Similar topics