Re: Question about External Tables -
08-18-2011
, 12:19 AM
Thanks for the help everyone. After some examination of this particular problem I found out that the problem is in the folder permissions that contained the csv file. After changing the permissions of the folder properly, it is now working on the client and server end.
Re: Question about External Tables -
08-18-2011
, 08:44 AM
Jack:
# Thanks for the help everyone. *After some examination of this
particular problem I found out that the problem is in the folder
permissions that contained the csv file.
....
Thanks for the update ... sorry it took you so long to chase it down.
Permissions and ownership issues will bite you big time with external
tables if you do not check carefully everything and every time. Part
of the documentation that you produce everytime you put together a new
script/job with an external table should verify the setup.
Thought I gave you a hint on my first reply on August 10th to look at
the permissions/etc but c'est la vie.
Re: Question about External Tables -
08-18-2011
, 05:17 PM
I am very appreciative of all the help, so there is no need to apologize. Normally when I look at permissions, I only check the file permissions and very often, forget about the folder. It took a while to figure it out, butI'm glad that it's sorted. Also learned a few new things about Oracle, sothe journey was well worth it.