Re: Oracle 7.2.3 emergency

Moin,

try to select (table by table) your data with a select * statement. After this you know if your database at least can read all the data.

I have had once a case where one entry in a primary key field was corrupt. Every select on this field in this special record sent the database to hell. Even by executing with a simple user with low level of rights (connect role).
After executing an update on this entry with the correct value everything was fine again.

Certainly it's only a smal chance that this is related to your problem.

h2h

Thomas Received on Sat Nov 10 2001 - 07:22:12 CST