OraFAQ Forum: Client Tools » about SAVE environment sqlplus command ....

Home » Other » Client Tools » about SAVE environment sqlplus command ....

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

about SAVE environment sqlplus command .... [message #228155]

Sun, 01 April 2007 17:20

m_arafa
Messages: 36
Registered: June 2006

Member

hi all,

when i write :-

...
SQL> save qry

this file is created in BIN directory , even though i type in 'REGEDIT' system file
in oracle directory
in SQLPATH 'D:\wok' only, not additional paths

thanx,

Report message to a moderator

Re: about SAVE environment sqlplus command .... [message #228157 is a reply to message #228155]

Sun, 01 April 2007 17:40

ebrian
Messages: 2794
Registered: April 2006

Senior Member

To my knowledge, SQLPATH sets the path where files will be executed FROM, not where they will be saved to. To save the file to a specific directory, you could just specify the path in addition to the filename.

Report message to a moderator

Re: about SAVE environment sqlplus command .... [message #228184 is a reply to message #228157]

Mon, 02 April 2007 00:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Furthermore, if you run SQL*Plus from the operating system command prompt (by typing "SQLPLUS username/password") instead of (on MS Windows) selecting it from "Programs - Oracle - Application Development - SQL*Plus", all files will be saved in a current directory.

For example:

M:\>sqlplus scott/tiger@ora10

SQL> select count(*) from dept;

  COUNT(*)
----------
         4

SQL> save cnt_dept.sql
Created file cnt_dept.sql
SQL> exit

M:\>dir cnt_dept.sql
 Volume in drive M is file sharing 1
 Volume Serial Number is 98A9-A7AE

 Directory of M:\

02.04.2007  07:41                30 cnt_dept.sql
               1 File(s)             30 bytes
               0 Dir(s)  1.130.334.281.728 bytes free

M:\>

Report message to a moderator

Re: about SAVE environment sqlplus command .... [message #228212 is a reply to message #228184]

Mon, 02 April 2007 01:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Forgot to mention ... if your SQL*Plus icon is on a desktop (MS Windows again), change its "Start in" property to desired directory (in your case, it would be "D:\wok").

Report message to a moderator

Previous Topic:	quest software - spotlight on oracle(bit urgent)
Next Topic:	Alternative to TOAD and SQL Oracle Developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 13:18:22 CST 2025