SQL*Plus (MOSC)

MOSC Banner

oracle default directory

edited Apr 28, 2010 10:35AM in SQL*Plus (MOSC) 14 commentsAnswered
Hello

I am unable to figure out where is oracle default directory set up

ORACLE @ddwgr04 >!pwd
/opt/oracle

ORACLE @ddwgr04 >spool t1
ORACLE @ddwgr04 >spool
currently spooling to /home/egurev1/myscripts/sql/t1.lst 

My current direcrtory is "/opt/oracle", but the spool file is created in another directory. My oracle_path is

ORACLE @ddwgr04 >!echo $ORACLE_PATH
.:/home/egurev1/myscripts/sql:/home/egurev1/myscripts/sql

It starts wit a "." so I thought that my current directory will be where spoolfile is created, but this is not the case.

How do I control where the spoolfiles are created? Client version is 11.1.0.7

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center