selecting table_name from dba_tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: selecting table_name from dba_tables

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Lightbulb

    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.

  2. #2
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    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

  3. #3
    Join Date
    Apr 2000
    Location
    Russia
    Posts
    11
    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

  4. #4
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    (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
  •  


Click Here to Expand Forum to Full Width