Solved

How do I fix errors that I get after running select stmt on external table

Posted on 2008-10-24
1
439 Views
Last Modified: 2013-12-21
I followed the steps to create an external table. However, when I try to select count(*) from the table I get the following error:

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04043: table column not found in external source: ABSTRACT
ORA-06512: at "SYS.ORACLE_LOADER", line 19


How do I fix this?
0
Comment
Question by:sikyala
1 Comment
 
LVL 4

Accepted Solution

by:
hqassap earned 500 total points
ID: 22802365
Read the following Metalink Note ID: 293310.1

If you need further assistance, provide the external table creation script

0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question