Database Utilities (MOSC)

MOSC Banner

difficulty understanding loader/external table paths/permissioning

edited Apr 4, 2014 12:00PM in Database Utilities (MOSC) 3 commentsAnswered

I have an application which loads/merges .txt files into database tables, which I am trying to port to Oracle. I've attempted both External Tables and SQL*Loader, but I am running into difficulties coding it to support remote operations. Specifically, operations where the data file may not exist on the same server as Oracle Database.

The problem is that Oracle Database is installed by default as a Local User on Windows. This means (apparently) that it cannot access network storage such as \\mybox\myfolder\data.txt. This is a problem because that's typically how I make the files available, since I may not have access to the filesystem on the box where Oracle Database is installed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center