Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Community (OTN)
This discussion is archived
on Aug 14, 2012 4:11 AM by JustinCave
Owner of table
Aug 14, 2012 2:53 AM
I am trying to get the owner of a created table
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
This content has been marked as final.
Show 1 reply
Re: Owner of table
Aug 14, 2012 4:11 AM
in response to
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';