-
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.
-
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.
_________________________
Joe Ramsey
Senior Database Administrator
dbaDirect, Inc.
(877)687-3227
-
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]
Tatyana
-
(may be ) it's a view or synonym , chek dhe dba_objects....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|