Home » RDBMS Server » Server Administration » conflicting queries for Oracle 7.3.4 databases
conflicting queries for Oracle 7.3.4 databases [message #369257] Thu, 27 July 2000 08:23 Go to next message
mand
Messages: 2
Registered: July 2000
Junior Member
Hi,

Please give some explanation for queries below ???

SQL> select count(*) from table1 ;

COUNT(*)
----------
10001

SQL> select * from table1 ;

no rows selected

Thanks in advance ,
Mand
Re: conflicting queries for Oracle 7.3.4 databases [message #369262 is a reply to message #369257] Thu, 27 July 2000 19:50 Go to previous message
Sam
Messages: 255
Registered: April 2000
Senior Member
It's so strange....

do the following and confirm...

analyze table TABLE1 compute statistics;

select num_rows from dba_tables where table_name = 'TABLE1';

what is it returning?

try out

best wishes
sam
Previous Topic: Re: resize redo log without shutting down instance ?
Next Topic: About DBMS_LOB.LOADFROMFILE.
Goto Forum:
  


Current Time: Thu Mar 28 11:08:05 CDT 2024