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.
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
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.
Senior Database Administrator
Try to use the next :
select table_name, owner from dba_tables where table_name
You may get some owners that have table 'CHECKING'.
select * from dba_tables where table_name = 'CHECKING'
[Edited by Tatyana on 11-30-2000 at 05:19 AM]
(may be ) it's a view or synonym , chek dhe dba_objects....
Click Here to Expand Forum to Full Width