| ORA-29829: implementation type does not exist [message #228668] |
Tue, 03 April 2007 10:46  |
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 #228906 is a reply to message #228668] |
Wed, 04 April 2007 09:03  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
