Re: Question about External Tables
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 10 Aug 2011 10:15:00 -0700 (PDT)
Message-ID: <71101c23-ef15-442d-b01c-2aac0a59a8d5_at_fq4g2000vbb.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 10:15:00 -0700 (PDT)
Message-ID: <71101c23-ef15-442d-b01c-2aac0a59a8d5_at_fq4g2000vbb.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!
Since the file exists on the database server were you using the same Oracle username when you connected? If not, does this second username have read privilege on the Oracle directory used in external table definition?
What tool was the remote session connected using? Have your tried the same test via sqlplus from a remote location?
What was the full version of Oracle? 10g is just a marketing label and 10.2.0.2 or whatever could be important if a bug is involved since bugs are usually version specific and sometimes are also platform specific.
HTH -- Mark D Powell -- Received on Wed Aug 10 2011 - 12:15:00 CDT