Oracle 8.1.6 Table

[Jean-Luc Oudart]

Hi Raj,

You said that my second query gave results eventhough took very long to run.
How long ?
(in sqlplus : set timing on)
could you run a trace on the session ?

Also, queries on other tables are fine : Are you on same tablespace as other tables ?
If not, could check the physical file(s) behind the tablespace and compare with other tablespaces ?

Regards,
Jean-Luc