OraFAQ Forum: Windows » How to Access files in a Server through a Local system in oracle

Home » Infrastructure » Windows » How to Access files in a Server through a Local system in oracle (Oracle 11g Database, MS Win Xp)

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

How to Access files in a Server through a Local system in oracle [message #634084]

Wed, 04 March 2015 04:12

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.

Report message to a moderator

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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

NET SHARE on the server.

NET USE on the client.

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

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

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.

Report message to a moderator

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

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Try NET SHARE.
HTH
-g

Report message to a moderator

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

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?

Report message to a moderator

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

gazzag
Messages: 1119
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

Report message to a moderator

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

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

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.

Report message to a moderator

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

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...

Report message to a moderator