Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-29829: implementation type does not exist
ORA-29829: implementation type does not exist [message #228668] Tue, 03 April 2007 10:46 Go to next message
systemsfsu
Messages: 2
Registered: March 2007
Junior Member
I am trying to use External Tables with Oracle 10g in a unix box. I have created a corresponding directory...all the settings seem to be fine but I keep getting this error for some reason.


Here dummy1 is the external table that I have created which needs to contain all the contents from my file...
--------------------------
SQL> select * from dummy1;
select * from dummy1
*
ERROR at line 1:
ORA-29829: implementation type does not exist
------------------------

Any help would be appreciated.

Thanks
-Sai

Re: ORA-29829: implementation type does not exist [message #228735 is a reply to message #228668] Wed, 04 April 2007 00:34 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
What does your table definition look like?
Re: ORA-29829: implementation type does not exist [message #228906 is a reply to message #228668] Wed, 04 April 2007 09:03 Go to previous message
systemsfsu
Messages: 2
Registered: March 2007
Junior Member
create table sysman.dummy1(
"SRCPHNUM" number(10),
"SRCNAME" varchar2(20),
"SRCLOCATION" varchar2(20),
"DESTNPHNUM" number(10),
"DESTNAME" varchar2(20),
"DESTLOCATION"varchar2(20),
"CALLTIME" number(3),
"COMMENTS" varchar2(20)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER DEFAULT DIRECTORY External_Tables1
ACCESS PARAMETERS(
RECORDS DELIMITED BY NEWLINE
BADFILE 'sat10_scores.bad'
LOGFILE'sat10_scores.log'
FIELDS terminated by ','
MISSING FIELD VALUES ARE NULL
)
LOCATION('Most_Critical.txt')
)
REJECT LIMIT UNLIMITED;


Thanks
-Sai





Previous Topic: checkbox values
Next Topic: apex installation issue
Goto Forum:
  


Current Time: Thu Mar 28 15:41:57 CDT 2024