OraFAQ Forum: Client Tools » Unable to View Table Names

Home » SQL & PL/SQL » Client Tools » Unable to View Table Names

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Unable to View Table Names [message #559018]

Thu, 28 June 2012 00:41

srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad

Member

Hi all

i'm working on sql developer in that i'm able to access tables if particular table name is given..

i dont understand is there any grant role problem ...

Kindly guide me

Thanks and regards

Report message to a moderator

Re: Unable to View Table Names [message #559021 is a reply to message #559018]

Thu, 28 June 2012 00:49

Littlefoot
Messages: 16960
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you own these tables, then you see them and - obviously - use them.

If you don't own them, can't see them but can use them, maybe the owner granted you access (and, possibly, created public synonyms).

If that's not the case, try to explain the current situation once again, providing as many details as possible.

Report message to a moderator

Re: Unable to View Table Names [message #559025 is a reply to message #559021]

Thu, 28 June 2012 01:04

srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad

Member

sorry...

for my user when i'm trying to click tables its not showing table names....

to view tables i'm excuting "select table_name from all_tables".....then i'm picking my table_name which i wanna work.....

Report message to a moderator

Re: Unable to View Table Names [message #559026 is a reply to message #559025]

Thu, 28 June 2012 01:05

Michel Cadot
Messages: 54155
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So is your problem solved or not?

Regards
Michel

Report message to a moderator

Re: Unable to View Table Names [message #559028 is a reply to message #559026]

Thu, 28 June 2012 01:30

Littlefoot
Messages: 16960
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

For my user when i'm trying to click tables its not showing table names

I there, perhaps, any FILTER set that prevents you from viewing your own tables?

Report message to a moderator

Re: Unable to View Table Names [message #559029 is a reply to message #559028]

Thu, 28 June 2012 01:44

srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad

Member

thanks...

no filter set is pined..

(+)tables after clicking dis.....

nothing was extracted just (+) disables...

Report message to a moderator

Re: Unable to View Table Names [message #559034 is a reply to message #559029]

Thu, 28 June 2012 02:04

Littlefoot
Messages: 16960
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You said that - when selecting from ALL_TABLES - you see them. Two questions:
a) what is the user name you are connecting to?
b) post the result of the following statement:

select owner, count(*)
from all_tables
group by owner
order by owner;

Report message to a moderator

Re: Unable to View Table Names [message #559036 is a reply to message #559034]

Thu, 28 June 2012 02:17

srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad

Member

my user:-srikanth
CTXSYS 3
EXFSYS 1
MDSYS 37
OLAPSYS 2
SYS 25
SYSTEM 8
STG 522

Thanks

Report message to a moderator

Re: Unable to View Table Names [message #559037 is a reply to message #559036]

Thu, 28 June 2012 02:23

Littlefoot
Messages: 16960
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As you can see, there are NO tables that belong to user named SRIKANTH.

That goes to my second "IF" (posted in my first reply here) - there are tables you are allowed to use, but they don't belong to you but to someone else.

Once you create your own tables (running the CREATE TABLE statement), you'll see them in SQL Developer under the "Tables" node.

Try it; for example, run