Home » SQL & PL/SQL » Client Tools » Run the Oracle sql script from shared mapped drive (Oracle 9i)
Run the Oracle sql script from shared mapped drive [message #466202] Sat, 17 July 2010 23:13 Go to next message
ygsunilkumar
Messages: 100
Registered: August 2008
Senior Member
I have stored test.sql in shared mapped drive and i don't have previlege to rename but i can read-write access at folder level.

How do i run the below sql script?

@\\ind-aaa\test\test.sql

Here \\ind-aaa\ is the mapped drive name.

I am getting error that \\ind not found.

Please help me. Thanks in Advance.
Re: Run the Oracle sql script from shared mapped drive [message #466203 is a reply to message #466202] Sat, 17 July 2010 23:16 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
>I am getting error that \\ind not found.
ERROR? What Error? I don't see any error.

don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Run the Oracle sql script from shared mapped drive [message #466208 is a reply to message #466202] Sun, 18 July 2010 00:00 Go to previous message
jenasatyabrata82
Messages: 21
Registered: July 2009
Location: INDIA
Junior Member
If you are working on windows platform,
then you can first mount the remote folder ,on your
local drive ,by using "net use" command ,available in dos.
Then you can run your sql script,as usual,because it is
mapped to your local drive.

For example ,you can mount the remote share \\ind-aaa\test\ ,
to some z: drive(or any drive name from a to z you can use,
if this drive ,doesn't already exist on your system).
Then you can run your sql script by

@z:\test.sql;

Net Use
------------------------------------------------------------

Connects a computer to or disconnects a computer from a shared resource, or displays information about computer connections. The command also controls persistent net connections. Used without parameters, net use retrieves a list of network connections.

Syntax
net use [{DeviceName | *}] [\\ComputerName\ShareName[\volume]] [{Password | *}]] [/user:[DomainName\]UserName] [/user:[DottedDomainName\]UserName] [/user: [UserName@DottedDomainName[/email][/email][/email]] [/savecred] [/smartcard] [{/delete | /persistent:{yes | no}}]

net use [DeviceName [/home[{Password | *}] [/delete:{yes | no}]]

net use [/persistent:{yes | no}]

Parameters
DeviceName
Assigns a name to connect to the resource or specifies the device to be disconnected. There are two kinds of device names: disk drives (that is, D: through Z:) and printers (that is, LPT1: through LPT3:). Type an asterisk (*) instead of a specific device name to assign the next available device name.
\\ComputerName\ShareName
Specifies the name of the server and the shared resource. If ComputerName contains spaces, use quotation marks around the entire computer name from the double backslash (\\) to the end of the computer name (for example, "\\Computer Name\Share Name"). The computer name can be from 1 to 15 characters long.
\volume
Specifies a NetWare volume on the server. You must have Client Service for NetWare installed and running to connect to NetWare servers.
Password
Specifies the password needed to access the shared resource. Type an asterisk (*) to produce a prompt for the password. The password is not displayed when you type it at the password prompt.
/user
Specifies a different user name with which the connection is made.
DomainName
Specifies another domain. If you omit DomainName, net use uses the current logged on domain.
UserName
Specifies the user name with which to log on.
DottedDomainName
Specifies the fully-qualified domain name for the domain where the user account exists.
/savecred
Stores the provided credentials for reuse.
/smartcard
Specifies the network connection is to use the credentials on a smart card. If multiple smart cards are available, you are asked to specify the credential.
/delete
Cancels the specified network connection. If you specify the connection with an asterisk (*), all network connections are canceled.
/persistent:{yes | no}
Controls the use of persistent network connections. The default is the setting used last. Deviceless connections are not persistent. Yes saves all connections as they are made, and restores them at next logon. No does not save the connection being made or subsequent connections. Existing connections are restored at the next logon. Use /delete to remove persistent connections.
/home
Connects a user to the home directory.
net help command
Displays help for the specified net command.
Remarks
Connecting and disconnecting from a network resource
Use net use to connect to and disconnect from a network resource, and to view your current connections to network resources. You cannot disconnect from a shared directory if you use it as your current drive or an active process is using it.

Viewing connection information
To view information about a connection, you can do either of the following:

Type net use DeviceName to get information about a specific connection.
Type net use to get a list of all the computer's connections.
Using deviceless connections
Deviceless connections are not persistent.

Connecting to NetWare servers
After you install and run Client Service for NetWare, you can connect to a NetWare server on a Novell network. Use the same syntax that you use to connect to a Windows Networking server, except you must include the volume you to which you want to connect.

Using quotation marks
If the ServerName that you supply contains spaces, use quotation marks around the text (that is, "Server Name"). If you omit quotation marks, an error message appears.

Examples
-----------------------------------------------------------
To assign the disk-drive device name E: to the Letters shared directory on the \\Financial server, type:

net use e: \\financial\letters

To assign (map) the disk-drive device name M: to the directory Mike within the Letters volume on the \\Financial NetWare server, type:

net use m: \\financial\letters\mike

To connect the user identifier Dan as if the connection were made from the Accounts domain, type:

net use d:\\server\share /user:Accounts\Dan

To disconnect from the \\Financial\Public directory, type:

net use f: \\financial\public /delete

To connect to the resource memos shared on the \\Financial 2 server, type:

net use k: "\\financial 2" \memos

To restore the current connections at each logon, regardless of future changes, type:

net use /persistent:yes

[Updated on: Sun, 18 July 2010 00:16]

Report message to a moderator

Previous Topic: run scripts
Next Topic: what's the best free oracle client tool?
Goto Forum:
  


Current Time: Wed Oct 22 00:57:51 CDT 2014

Total time taken to generate the page: 0.08525 seconds