This discussion is archived
1 Reply Latest reply: Aug 13, 2012 9:11 PM by Justin Cave RSS

Owner of table

952066 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points