Path Name Help

Path Name Help

[Sanjay Gupta]

OS : Win NT 4.0 SP 6a

I am writing shell script which does Oracle Export. In the script, I have to
give the name of export file, I am not sure how to include the path
information.

Example :-

exp system/manager file=/usr/exp.dmp  full=Y

see the file= parameter, when I use the above command then the Oracle exp
utility is not able to recognize the file information, it gives error
"failed to open /usr/exp.dmp for write"
So looks like unix style path does not work.

Then I tried window style path

exp system/manager file=d:\Oracle8i\Exp\Exp.dmp  full=Y

This works but it does not create file in d:\Oracle8i\Exp directory but in
creates file in D root directory i.e. in D:\ with name  oracle8iexpexp.dmp.
So this also does not create file in appropiate directory.

Please help me.

Thanks in Advance.



--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Path Name Help

[Larry Hall (RFK Partners, Inc)]

At 03:34 PM 2/28/2002, Sanjay Gupta wrote:
>OS : Win NT 4.0 SP 6a
>
>I am writing shell script which does Oracle Export. In the script, I have to
>give the name of export file, I am not sure how to include the path
>information.
>
>Example :-
>
>exp system/manager file=/usr/exp.dmp  full=Y
>
>see the file= parameter, when I use the above command then the Oracle exp
>utility is not able to recognize the file information, it gives error
>"failed to open /usr/exp.dmp for write"
>So looks like unix style path does not work.
>
>Then I tried window style path
>
>exp system/manager file=d:\Oracle8i\Exp\Exp.dmp  full=Y
>
>This works but it does not create file in d:\Oracle8i\Exp directory but in
>creates file in D root directory i.e. in D:\ with name  oracle8iexpexp.dmp.
>So this also does not create file in appropiate directory.


Sounds like a problem that you should be asking Oracle about, or am I 
missing why this is a Cygwin issue?



Larry Hall                              lhall@rfk.com
RFK Partners, Inc.                      http://www.rfk.com
838 Washington Street                   (508) 893-9779 - RFK Office
Holliston, MA 01746                     (508) 893-9889 - FAX


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Path Name Help

[Michael A Chase]

----- Original Message -----
From: "Sanjay Gupta" <SGupta@Epylon.com>
To: "'Larry Hall (RFK Partners, Inc)'" <lhall@rfk.com>; <cygwin@cygwin.com>
Sent: Thursday, February 28, 2002 13:10
Subject: RE: Path Name Help


> Thanks for helpful information.
> If I put the double quotes as you have suggested, it worked in cygwin.
>
> exp system/manager file="d:\Oracle8i\Exp\Exp.dmp"  full=Y

You can also use cygpath to convert Cygwin paths to Win32 paths which are
what Oracle programs understand since they haven't been ported to Cygwin
yet. <G>

Visit the Cygwin site (http://cygwin.com/) for lots of useful information.
You should at least read http://cygwin.com/cygwin-ug-net/cygwin-ug-net.html
to learn about the Cygwin utilities.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: Path Name Help

[Sanjay Gupta]

Thanks for helpful information. 
If I put the double quotes as you have suggested, it worked in cygwin.

exp system/manager file="d:\Oracle8i\Exp\Exp.dmp"  full=Y

Thanks again.


-----Original Message-----
From: Larry Hall (RFK Partners, Inc) [mailto:lhall@rfk.com]
Sent: Thursday, February 28, 2002 12:55 PM
To: Sanjay Gupta; 'cygwin@cygwin.com'
Subject: RE: Path Name Help


OK, then you want to review some good documents on basic tenants of UNIX and
it's shells.  

This is neither an Oracle issue nor a Cygwin one.  It's a cockpit error.
For this particular issue, you can resolve your problem by quoting your 
path or escaping the backslashes.  You may find that 'exp' allows you to 
use '/' for the path separator, in which case you can substitute it for 
'\' and not need to make any other syntax changes.  But that's dependent 
on how strict 'exp' is with path separators.  I personally can't say.

Reading up on how UNIX shells works would be a good basis for your 
continued work in this area and save you the time of looking for a list
to post future questions like this to.


Larry Hall                              lhall@rfk.com
RFK Partners, Inc.                      http://www.rfk.com
838 Washington Street                   (508) 893-9779 - RFK Office
Holliston, MA 01746                     (508) 893-9889 - FAX


At 03:48 PM 2/28/2002, Sanjay Gupta wrote:
>I am not sure whether this is Oracle issue because if I use the same
command
>from the command prompt of Windows, it does work.
>e.g. the following command works from windows does prompt. The files gets
>created in d:\oracle8i\exp directory. 
>exp system/manager file=d:\Oracle8i\Exp\Exp.dmp  full=Y
>
>but the same thing does not work well when executed from cygwin shell.
>
>
>-----Original Message-----
>From: Larry Hall (RFK Partners, Inc) [mailto:lhall@rfk.com]
>Sent: Thursday, February 28, 2002 12:38 PM
>To: Sanjay Gupta; 'cygwin@cygwin.com'
>Subject: Re: Path Name Help
>
>
>At 03:34 PM 2/28/2002, Sanjay Gupta wrote:
> >OS : Win NT 4.0 SP 6a
> >
> >I am writing shell script which does Oracle Export. In the script, I have
>to
> >give the name of export file, I am not sure how to include the path
> >information.
> >
> >Example :-
> >
> >exp system/manager file=/usr/exp.dmp  full=Y
> >
> >see the file= parameter, when I use the above command then the Oracle exp
> >utility is not able to recognize the file information, it gives error
> >"failed to open /usr/exp.dmp for write"
> >So looks like unix style path does not work.
> >
> >Then I tried window style path
> >
> >exp system/manager file=d:\Oracle8i\Exp\Exp.dmp  full=Y
> >
> >This works but it does not create file in d:\Oracle8i\Exp directory but
in
> >creates file in D root directory i.e. in D:\ with name
oracle8iexpexp.dmp.
> >So this also does not create file in appropiate directory.
>
>
>Sounds like a problem that you should be asking Oracle about, or am I 
>missing why this is a Cygwin issue?
>
>
>
>Larry Hall                              lhall@rfk.com
>RFK Partners, Inc.                      http://www.rfk.com
>838 Washington Street                   (508) 893-9779 - RFK Office
>Holliston, MA 01746                     (508) 893-9889 - FAX
>
>--
>Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
>Bug reporting:         http://cygwin.com/bugs.html
>Documentation:         http://cygwin.com/docs.html
>FAQ:                   http://cygwin.com/faq/

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: Path Name Help

[Larry Hall (RFK Partners, Inc)]

OK, then you want to review some good documents on basic tenants of UNIX and
it's shells.  

This is neither an Oracle issue nor a Cygwin one.  It's a cockpit error.
For this particular issue, you can resolve your problem by quoting your 
path or escaping the backslashes.  You may find that 'exp' allows you to 
use '/' for the path separator, in which case you can substitute it for 
'\' and not need to make any other syntax changes.  But that's dependent 
on how strict 'exp' is with path separators.  I personally can't say.

Reading up on how UNIX shells works would be a good basis for your 
continued work in this area and save you the time of looking for a list
to post future questions like this to.


Larry Hall                              lhall@rfk.com
RFK Partners, Inc.                      http://www.rfk.com
838 Washington Street                   (508) 893-9779 - RFK Office
Holliston, MA 01746                     (508) 893-9889 - FAX


At 03:48 PM 2/28/2002, Sanjay Gupta wrote:
>I am not sure whether this is Oracle issue because if I use the same command
>from the command prompt of Windows, it does work.
>e.g. the following command works from windows does prompt. The files gets
>created in d:\oracle8i\exp directory. 
>exp system/manager file=d:\Oracle8i\Exp\Exp.dmp  full=Y
>
>but the same thing does not work well when executed from cygwin shell.
>
>
>-----Original Message-----
>From: Larry Hall (RFK Partners, Inc) [mailto:lhall@rfk.com]
>Sent: Thursday, February 28, 2002 12:38 PM
>To: Sanjay Gupta; 'cygwin@cygwin.com'
>Subject: Re: Path Name Help
>
>
>At 03:34 PM 2/28/2002, Sanjay Gupta wrote:
> >OS : Win NT 4.0 SP 6a
> >
> >I am writing shell script which does Oracle Export. In the script, I have
>to
> >give the name of export file, I am not sure how to include the path
> >information.
> >
> >Example :-
> >
> >exp system/manager file=/usr/exp.dmp  full=Y
> >
> >see the file= parameter, when I use the above command then the Oracle exp
> >utility is not able to recognize the file information, it gives error
> >"failed to open /usr/exp.dmp for write"
> >So looks like unix style path does not work.
> >
> >Then I tried window style path
> >
> >exp system/manager file=d:\Oracle8i\Exp\Exp.dmp  full=Y
> >
> >This works but it does not create file in d:\Oracle8i\Exp directory but in
> >creates file in D root directory i.e. in D:\ with name  oracle8iexpexp.dmp.
> >So this also does not create file in appropiate directory.
>
>
>Sounds like a problem that you should be asking Oracle about, or am I 
>missing why this is a Cygwin issue?
>
>
>
>Larry Hall                              lhall@rfk.com
>RFK Partners, Inc.                      http://www.rfk.com
>838 Washington Street                   (508) 893-9779 - RFK Office
>Holliston, MA 01746                     (508) 893-9889 - FAX
>
>--
>Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
>Bug reporting:         http://cygwin.com/bugs.html
>Documentation:         http://cygwin.com/docs.html
>FAQ:                   http://cygwin.com/faq/


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: Path Name Help

[Sanjay Gupta]

I am not sure whether this is Oracle issue because if I use the same command
from the command prompt of Windows, it does work.
e.g. the following command works from windows does prompt. The files gets
created in d:\oracle8i\exp directory. 
exp system/manager file=d:\Oracle8i\Exp\Exp.dmp  full=Y

but the same thing does not work well when executed from cygwin shell.


-----Original Message-----
From: Larry Hall (RFK Partners, Inc) [mailto:lhall@rfk.com]
Sent: Thursday, February 28, 2002 12:38 PM
To: Sanjay Gupta; 'cygwin@cygwin.com'
Subject: Re: Path Name Help


At 03:34 PM 2/28/2002, Sanjay Gupta wrote:
>OS : Win NT 4.0 SP 6a
>
>I am writing shell script which does Oracle Export. In the script, I have
to
>give the name of export file, I am not sure how to include the path
>information.
>
>Example :-
>
>exp system/manager file=/usr/exp.dmp  full=Y
>
>see the file= parameter, when I use the above command then the Oracle exp
>utility is not able to recognize the file information, it gives error
>"failed to open /usr/exp.dmp for write"
>So looks like unix style path does not work.
>
>Then I tried window style path
>
>exp system/manager file=d:\Oracle8i\Exp\Exp.dmp  full=Y
>
>This works but it does not create file in d:\Oracle8i\Exp directory but in
>creates file in D root directory i.e. in D:\ with name  oracle8iexpexp.dmp.
>So this also does not create file in appropiate directory.


Sounds like a problem that you should be asking Oracle about, or am I 
missing why this is a Cygwin issue?



Larry Hall                              lhall@rfk.com
RFK Partners, Inc.                      http://www.rfk.com
838 Washington Street                   (508) 893-9779 - RFK Office
Holliston, MA 01746                     (508) 893-9889 - FAX

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/