开发者

moving file from desktop to Oracle directory

I have created a directory in Oracle via the command create directory. The directory is called temp. I have a file located on:

G:\Documents\SO\Content\102010 Stack Overflow\test.xml开发者_如何学Go

that I want to put in this directory. How can I do this via a SQL statement?


Oracle's directory feature is not meant to enable file transfer from a client to the server. If you want to put a file there for Oracle's use (e.g. as an external table), then the standard way that is done is for the dba or system administrator to move the file into the appropriate directory on the server; or for them to grant you access via standard file-sharing means.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜