OraFAQ Forum: Server Administration » How to change current working directory in Oracle

Home » RDBMS Server » Server Administration » How to change current working directory in Oracle

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

How to change current working directory in Oracle [message #283886]

Wed, 28 November 2007 06:14

abo_mahmoud
Messages: 31
Registered: May 2006
Location: UAE

Member

Hi all:
Is it a silly question ? .... Maybe
How to change current working directory in Oracle?
(I'm installing Oracle Application Express on Oracle DB Enterprise edition)

Report message to a moderator

Re: How to change current working directory in Oracle [message #284056 is a reply to message #283886]

Wed, 28 November 2007 12:12

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

What you mean changing current directory?

Report message to a moderator

Re: How to change current working directory in Oracle [message #284108 is a reply to message #283886]

Wed, 28 November 2007 23:02

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 29 11:00:58 2007

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> !pwd
/oradata2/arju

SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
-bash-3.00$ cd /oradata1
-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 29 11:02:33 2007

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> !pwd
/oradata1

Report message to a moderator

Re: How to change current working directory in Oracle [message #284114 is a reply to message #283886]

Wed, 28 November 2007 23:37

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Like Arju said ..

prefix "!" to all unix commands from SQL> prompt

eg :
SQL>!cd /u01/oracle

Report message to a moderator

Re: How to change current working directory in Oracle [message #284134 is a reply to message #284114]

Thu, 29 November 2007 00:12

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This spawns a process that will work in the given directory, this does not change the directory in which SQL*Plus is working.

Regards
Michel

Report message to a moderator

Re: How to change current working directory in Oracle [message #284302 is a reply to message #283886]

Thu, 29 November 2007 06:00

abo_mahmoud
Messages: 31
Registered: May 2006
Location: UAE

Member

-I told you it's a Silly Question-
The solution is to create a shortcut for sql*plus -e.g in desktop (windows)- and at its properties copy the desired directory in 'start in' field.

Thanks

Report message to a moderator

Previous Topic:	Please guide me in Database Cloning
Next Topic:	Help - Long running alter table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 13:57:09 CST 2025