dbTalk Databases Forums  

Question about External Tables

comp.databases.oracle.server comp.databases.oracle.server


Discuss Question about External Tables in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
Jack Schmidt
 
Posts: n/a

Default 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.

Again, I really appreciate all the help.

Reply With Quote
  #22  
Old   
John Hurley
 
Posts: n/a

Default 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.

Reply With Quote
  #23  
Old   
Jack Schmidt
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.