ORA-29829: implementation type does not exist

[systemsfsu]

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

 

[karluk]

It looks as if ALL_OBJECTS is created in catalog.sql and ORACLE_LOADER in catproc.sql, so if those two scripts run without error you should be able to execute the "select ... from all_objects" query without getting the ORA-00942 error.

 

[systemsfsu]

Karluk,

I did try running these scripts..now things have gone worser.

1. The script had some errors while executing.

2. Now for every query which I type I get the error ORA01092..like this one..

SQL> startup mount;
ORACLE instance started.

Total System Global Area 138412032 bytes
Fixed Size 1218052 bytes
Variable Size 117443068 bytes
Database Buffers 16777216 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

-Sai

 

[karluk]

So, what were the errors? You need to get at least catalog.sql and catproc.sql to execute without significant errors before opening your database.

 

[karluk]

Also, check your alert log. It will probably contain some additional information as to why the database failed to open.

 

[systemsfsu]

Karluk,

The problem was with the Oracle installation and now it seems to work fine..

Thanks for all ur help...thank u guys!!

-Sai