PL/SQL (MOSC)

MOSC Banner

How to load data from a .txt in virtual directory EXCEL to oracle tables?

edited Jan 27, 2010 4:34AM in PL/SQL (MOSC) 7 commentsAnswered ✓
 I ave a script ksh that has sqlldr and has the username and passowrd inside the script in order to load the data.  I wonder if the loading can be place in a procedure to be able to load the .txt inside the server.  I have created a virtual directory in this directory where the .txt is located and have granted read,write permission to the user cmprtrel2 which is the user that will be loading the data.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center