Re: Major dissapointment

MK was kind enough to write:
> Hi group,
> The biggest dissapointment with Oracle so far:
>
>
> SQL> select count(*) from factTable;
> select count(*) from factTable
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
>
>
> This doesn't happen on other tables in the database,
> only on this table. It's absolutely reproducible, that is, it
> happens every time I run the trivial query above.
>
> It's a partitioned table, otherwise a completely normal
> table. I also have other tables in the same schema which
> don't cause any problems. Ora 8.1.6 EE on Win 2000
> Server. Any info on this error? Thx,
>

Since it's only that one table, what happens if you create a view with a completely different name -- for example:

  create view xyz as select * from facttable;

then:

  select count(*) from xyz;

Also, check to see if you have any synonyms named facttable that point to non-existent tables.

-- 
[:%s/Karsten Farrell/Oracle DBA/g]