Home » RDBMS Server » Server Administration » How to change current working directory in Oracle
How to change current working directory in Oracle [message #283886] Wed, 28 November 2007 06:14 Go to next message
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)

Re: How to change current working directory in Oracle [message #284056 is a reply to message #283886] Wed, 28 November 2007 12:12 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
cd Wink

What you mean changing current directory?
Re: How to change current working directory in Oracle [message #284108 is a reply to message #283886] Wed, 28 November 2007 23:02 Go to previous messageGo to next message
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
Re: How to change current working directory in Oracle [message #284114 is a reply to message #283886] Wed, 28 November 2007 23:37 Go to previous messageGo to next message
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
Re: How to change current working directory in Oracle [message #284134 is a reply to message #284114] Thu, 29 November 2007 00:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to change current working directory in Oracle [message #284302 is a reply to message #283886] Thu, 29 November 2007 06:00 Go to previous message
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
Previous Topic: Please guide me in Database Cloning
Next Topic: Help - Long running alter table
Goto Forum:
  


Current Time: Sun Dec 04 14:34:09 CST 2016

Total time taken to generate the page: 0.26025 seconds