selecting table_name from dba_tables

[dorothy]

Hello,
I have a table called CHECKING so I logged on with dba role and issued this statement:
select table_name, owner from dba_tables where table_name = 'CHECKING'
I received no row selected.
Am I doing something wrong?

I also issued select * from dba_tables where table_name = 'CHECKING'
Again, I received:
no row selected.

[wjramsey]

Are you positive the account has the dba role? Maybe you mispelled the table name?

I did the following:

create user test identified by test;
grant dba to test
select table_name, owner
from dba_tables
where table_name = 'RENTAL_SALE_FACT'
/
and it came back with the table name and owner.

I would check the spelling and the role and make sure both are correct.

[Tatyana]

Hi, Dorothy!
Try to use the next :
select table_name, owner from dba_tables where table_name
like '%CHECKING%';
You may get some owners that have table 'CHECKING'.

select * from dba_tables where table_name = 'CHECKING'
and owner='INTERESTING_YOU';

[Edited by Tatyana on 11-30-2000 at 05:19 AM]

[aracnid]

(may be ) it's a view or synonym , chek dhe dba_objects....