Database Utilities (MOSC)

MOSC Banner

external table -- Issues with specific data

edited Nov 9, 2012 5:53AM in Database Utilities (MOSC) 9 commentsAnswered ✓
Hi,

I am receiving the following error, when I am trying  to fetch the data with the external table.   I have tried with the sqlloader for the same and it worked without any issues.   Just to be noted, It is working fine, if I exclude the year and month columns from the external table. For some reason, it is having issues with year and month data. 

 

Your inputs on this issue greatly appreciated. 

 

SQL> select count(*) from XTERN_YTD_PREMIUM_TRANS;

select count(*) from XTERN_YTD_PREMIUM_TRANS

*

ERROR at line 1:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center