Re: Question about External Tables
From: ddf <oratune_at_msn.com>
Date: Wed, 10 Aug 2011 16:57:10 -0700 (PDT)
Message-ID: <3481497b-41bf-4fee-a399-03612c95cc6e_at_k3g2000vbz.googlegroups.com>
On Aug 10, 1: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 16:57:10 -0700 (PDT)
Message-ID: <3481497b-41bf-4fee-a399-03612c95cc6e_at_k3g2000vbz.googlegroups.com>
On Aug 10, 1: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!
How is the directory EXT_TEST defined in the database?
David Fitzjarrell Received on Wed Aug 10 2011 - 18:57:10 CDT