Home » SQL & PL/SQL » Client Tools » Unable to View Table Names
Unable to View Table Names [message #559018] Thu, 28 June 2012 00:41 Go to next message
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
Re: Unable to View Table Names [message #559021 is a reply to message #559018] Thu, 28 June 2012 00:49 Go to previous messageGo to next message
Littlefoot
Messages: 19350
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.
Re: Unable to View Table Names [message #559025 is a reply to message #559021] Thu, 28 June 2012 01:04 Go to previous messageGo to next message
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.....
Re: Unable to View Table Names [message #559026 is a reply to message #559025] Thu, 28 June 2012 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So is your problem solved or not?

Regards
Michel
Re: Unable to View Table Names [message #559028 is a reply to message #559026] Thu, 28 June 2012 01:30 Go to previous messageGo to next message
Littlefoot
Messages: 19350
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?
Re: Unable to View Table Names [message #559029 is a reply to message #559028] Thu, 28 June 2012 01:44 Go to previous messageGo to next message
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...
Re: Unable to View Table Names [message #559034 is a reply to message #559029] Thu, 28 June 2012 02:04 Go to previous messageGo to next message
Littlefoot
Messages: 19350
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;
Re: Unable to View Table Names [message #559036 is a reply to message #559034] Thu, 28 June 2012 02:17 Go to previous messageGo to next message
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
Re: Unable to View Table Names [message #559037 is a reply to message #559036] Thu, 28 June 2012 02:23 Go to previous messageGo to next message
Littlefoot
Messages: 19350
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
create table test (col number);
and check "Tables" again - don't forget to refresh the left side (Ctrl + R)!
Re: Unable to View Table Names [message #559038 is a reply to message #559037] Thu, 28 June 2012 02:27 Go to previous messageGo to next message
srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad
Member
ok ok

when i'm trying to create table its throwing error insufficient privileges...

Thanks
Re: Unable to View Table Names [message #559039 is a reply to message #559038] Thu, 28 June 2012 02:35 Go to previous messageGo to next message
Littlefoot
Messages: 19350
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It means that, when your user (SRIKANTH) was created, you were not granted the CREATE TABLE privilege. Ask your DBA to grant it to you.
Re: Unable to View Table Names [message #559641 is a reply to message #559039] Thu, 05 July 2012 04:16 Go to previous message
srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad
Member
thanx
Previous Topic: exporting result into excel or text file
Next Topic: Able to connect from SQL-Assistant BUT unable to connect from Sql Developer
Goto Forum:
  


Current Time: Fri Aug 01 19:58:13 CDT 2014

Total time taken to generate the page: 0.13688 seconds