Re: Question about External Tables
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Wed, 10 Aug 2011 05:05:21 -0700 (PDT)
Message-ID: <e4fbe40c-a3de-4cc1-a7f3-9a103fe68aca_at_h14g2000yqd.googlegroups.com>
On Aug 10, 4:44 am, Jack Schmidt <thejackschm..._at_gmail.com> wrote:
> I've been playing around on 10g with External tables and I have been able to load up csv files on them.
>
> The problem I seem to run into is that if I use the SQL*Plus on a remote Oracle client and try to select the external table, I get:
>
> ORA-29400: data cartridge error
> KUP-04040: file temp.csv in EXT_TEST not found
> ORA-06512: at "SYS.ORACLE_LOADER", line 19
>
> I know that the temp.csv file resides on the database server and I am able to select its contents on SQL*Plus at the database server. I am not able to when I am connecting via remote Oracle client.
>
> Can anyone tell me what I might be missing here?
>
> Would greatly appreciate some help here.
>
> Thanks!
Date: Wed, 10 Aug 2011 05:05:21 -0700 (PDT)
Message-ID: <e4fbe40c-a3de-4cc1-a7f3-9a103fe68aca_at_h14g2000yqd.googlegroups.com>
On Aug 10, 4:44 am, Jack Schmidt <thejackschm..._at_gmail.com> wrote:
> I've been playing around on 10g with External tables and I have been able to load up csv files on them.
>
> The problem I seem to run into is that if I use the SQL*Plus on a remote Oracle client and try to select the external table, I get:
>
> ORA-29400: data cartridge error
> KUP-04040: file temp.csv in EXT_TEST not found
> ORA-06512: at "SYS.ORACLE_LOADER", line 19
>
> I know that the temp.csv file resides on the database server and I am able to select its contents on SQL*Plus at the database server. I am not able to when I am connecting via remote Oracle client.
>
> Can anyone tell me what I might be missing here?
>
> Would greatly appreciate some help here.
>
> Thanks!
External tables have to reside on the database server "somehow". One way to do it is using an NFS mounted system ... that's what we do it here.
With NFS the client has access to the file system ... it really is from the client system. Plus the database server can access it.
Permissions can be a little tricky but it is workable depending if the client is an application server kind of setup.
For each individual client ... better figure out some way of getting the files onto a common NFS mount point or getting them actually over to the database server.
SQL Developer has interfaces for getting files back and forth. Received on Wed Aug 10 2011 - 07:05:21 CDT