1 Reply Latest reply: Aug 13, 2012 11:11 PM by JustinCave RSS

    Owner of table

    952066
      I am trying to get the owner of a created table test but it shows no rows selected, as my table is having 8 rows already. please see below and assist me where I am wrong.



      SQL> select * from test;

      FLAT_MEMBERS_ID FIRST_NAME LAST_NAME AGE
      --------------- ---------- ---------- ----------
      1 Himanshu Gupta 24
      2 Tarun Goyal 26
      3 Vipul Jain 27
      4 Sourabh Singh 26
      5 Vidya Pandey 24
      6 Ankit Bhardwaj 25
      7 Shahnawaz Ahmed 26
      8 Yogesh singh 24

      8 rows selected.

      SQL> select owner, table_name, tablespace_name from dba_tables where table_name='test';

      no rows selected
        • 1. Re: Owner of table
          JustinCave
          Unless you are using case-sensitive identifiers, object names are stored in upper case in the data dictionary.
          select owner, table_name, tablespace_name 
            from dba_tables 
           where table_name='TEST';
          Justin