Home » Infrastructure » Windows » How to Access files in a Server through a Local system in oracle (Oracle 11g Database, MS Win Xp)
icon5.gif  How to Access files in a Server through a Local system in oracle [message #634084] Wed, 04 March 2015 04:12 Go to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Hi,

I have some files(eg: xml, txt) in a file server, well in the same network
i need to access or read those files from my system, how can we achieve this.
previously i was having those files from my same machine, now this should be
achieved from a different machine.

For the local machine: Directories were created for specific drive and grants were also given;

D:\Project1\

so the above this is not a problem when accessing within a local machine,
how to get or create a directory into a file_server/backup_server, and
access those files from a local machine? how to set these things?

Pls give some ideas!

Stanlee.


Re: How to Access files in a Server through a Local system in oracle [message #634085 is a reply to message #634084] Wed, 04 March 2015 04:19 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
NET SHARE on the server.

NET USE on the client.
Re: How to Access files in a Server through a Local system in oracle [message #634086 is a reply to message #634084] Wed, 04 March 2015 04:23 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'll have to create a directory (Oracle object) which will point to file system directory which contains those files. If they were on a database server - no problem. As they are on a file server (which is, I presume, different from your database server) - no problem either. You'll just have to use UNC notation.
Re: How to Access files in a Server through a Local system in oracle [message #634087 is a reply to message #634085] Wed, 04 March 2015 04:23 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
gazzag wrote on Wed, 04 March 2015 17:19
NET SHARE on the server.

NET USE on the client.


Hi Gazzag,

I dont have any idea about net share.
Re: How to Access files in a Server through a Local system in oracle [message #634088 is a reply to message #634087] Wed, 04 March 2015 04:26 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Try NET SHARE.
HTH
-g
Re: How to Access files in a Server through a Local system in oracle [message #634089 is a reply to message #634086] Wed, 04 March 2015 04:32 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Littlefoot wrote on Wed, 04 March 2015 17:23
You'll have to create a directory (Oracle object) which will point to file system directory which contains those files. If they were on a database server - no problem. As they are on a file server (which is, I presume, different from your database server) - no problem either. You'll just have to use UNC notation.


Im not a network guy, can you give an example please?
Re: How to Access files in a Server through a Local system in oracle [message #634090 is a reply to message #634089] Wed, 04 March 2015 04:40 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
On the server:
SQL> CREATE DIRECTORY project1 
       AS 'D:\PROJECT1';

C:\> NET SHARE PROJECT1=D:\PROJECT1

On the client:
NET USE <drive_letter> \\<DB_Server_name>\PROJECT1
Re: How to Access files in a Server through a Local system in oracle [message #634091 is a reply to message #634089] Wed, 04 March 2015 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just search for UNC, no need to be a network expert.
But you have to know that Oracle account has no right on network and must NOT have any.
So, anyway, you can't achieve what you want from Oracle database.

Re: How to Access files in a Server through a Local system in oracle [message #634092 is a reply to message #634091] Wed, 04 March 2015 05:03 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Michel Cadot wrote on Wed, 04 March 2015 17:42

Just search for UNC, no need to be a network expert.
But you have to know that Oracle account has no right on network and must NOT have any.
So, anyway, you can't achieve what you want from Oracle database.



Hi Michel,

I have found out in google these below;

UNC Name Examples

Consider a standard Windows XP computer named teela . In addition to the built-in admin$ share, say you have also defined a share point called temp that is located at C:\temp. Using UNC names, you would connect to folders on teela as follows:
\\teela\admin$ (to reach C:\WINNT)
\\teela\admin$\system32 (to reach C:\WINNT\system32)
\\teela\temp (to reach C:\temp)

well i will try it out and say, mean while i will try gazzag's idea;

Thanks...
Re: How to Access files in a Server through a Local system in oracle [message #634094 is a reply to message #634092] Wed, 04 March 2015 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And you will fail due to the reasons I mentioned.

Re: How to Access files in a Server through a Local system in oracle [message #634096 is a reply to message #634084] Wed, 04 March 2015 07:29 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Actually, I'm wondering where oracle comes into the picture at all ...
Re: How to Access files in a Server through a Local system in oracle [message #634097 is a reply to message #634096] Wed, 04 March 2015 07:59 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Quote:
Directories were created for specific drive and grants were also given;

Tenuous, granted Wink
Previous Topic: install oracle database 11g on win xp
Next Topic: Window script
Goto Forum:
  


Current Time: Thu Mar 28 14:46:54 CDT 2024