OraFAQ Forum: Client Tools » tables are not getting displayed under schema in sqldeveloper

Home » Other » Client Tools » tables are not getting displayed under schema in sqldeveloper (oracle 11g /Windows 7-32bit )

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

tables are not getting displayed under schema in sqldeveloper [message #608363]

Wed, 19 February 2014 03:28

prejib
Messages: 126
Registered: March 2009
Location: India

Senior Member

Hi ,
I am connecting to a schema - catalog having 100s of tables through sql developer . When I expand the 'tables' under the connection , the tables are not getting displayed. If check the same through Toad , I am able to see the same . Can you please help me to solve this issue since the dev team is facing this issue . Version detials are given below

Oracle Version
SQL> select banner from v$version;

BANNER
------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL DEVELOPER
--------------

About
-----

Oracle SQL Developer 3.0.04
 Version 3.0.04
Build MAIN-04.34
Copyright ©  2005, 2011 Oracle.  All Rights Reserved.
IDE Version: 11.1.1.4.37.59.31
Product ID: oracle.sqldeveloper
Product Version: 11.1.2.04.34

Version
-------

Component	Version
=========	=======
Java(TM) Platform	1.6.0_11
Oracle IDE	3.0.04.34
Versioning Support	3.0.04.34
 
Count of records in schema
--------------------------- 
SQL> show user
USER is "CATA"
SQL> select count(*) from tab;

  COUNT(*)
----------
       753

SQL>

Attachment: schema_cata.jpg
(Size: 110.04KB, Downloaded 1990 times)

Report message to a moderator

Re: tables are not getting displayed under schema in sqldeveloper [message #608364 is a reply to message #608363]

Wed, 19 February 2014 03:31

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

what does

select count(*) from user_tables

give?

Report message to a moderator

Re: tables are not getting displayed under schema in sqldeveloper [message #608365 is a reply to message #608363]

Wed, 19 February 2014 03:49

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

In addition to cookiemonster's question, what does the following give you?

SQL> SELECT * FROM GLOBAL_NAME;

Report message to a moderator

Re: tables are not getting displayed under schema in sqldeveloper [message #608366 is a reply to message #608365]

Wed, 19 February 2014 03:56

prejib
Messages: 126
Registered: March 2009
Location: India

Senior Member

SQL> select count(*) from user_tables
  2  ;

  COUNT(*)
----------
       271

SQL> SELECT * FROM GLOBAL_NAME;

GLOBAL_NAME
--------------------------------------------------------------
DEV.abc.COM  -->( exact name is not provided)

Report message to a moderator

Re: tables are not getting displayed under schema in sqldeveloper [message #608381 is a reply to message #608366]

Wed, 19 February 2014 05:15

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

Senior Member
Account Moderator

It seems that objects you see in TOAD and not in SQL Developer aren't just tables but something else as well. TOAD, under tables, displays "ordinary" tables, materialized views, global temporary tables.

This query will tell you how many objects you have in that schema:

select object_type, count(*) from user_objects group by object_type;

If SQL Developer displays only tables under the "Tables" node, and that number matches the one you get with the above query, then you'll know what makes the difference. Other objects can be accessed under their own nodes in SQL Developer.

Report message to a moderator

Re: tables are not getting displayed under schema in sqldeveloper [message #608392 is a reply to message #608381]

Wed, 19 February 2014 05:55

prejib
Messages: 126
Registered: March 2009
Location: India

Senior Member

I have solved this issue by executing the below command from command prompt..

now I am able to view all the tables under the schema .
Thanks ..

D:\Software\sqldeveloper>sqldeveloper -J-Doracle.net.disableOob=true

D:\Software\sqldeveloper>

Report message to a moderator

Re: tables are not getting displayed under schema in sqldeveloper [message #608398 is a reply to message #608392]

Wed, 19 February 2014 06:40

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

Senior Member
Account Moderator

Google says that it is a workaround to avoid bug; could you upgrade SQL Developer to its latest version and see how it behaves? I believe/hope that it is solved by now (current release is 4.0.0.13.80 while yours is 3.0.04).

Report message to a moderator

Previous Topic:	DEFINE VARIABLES and AMPERSAND
Next Topic:	Convertion of text from german to english

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 16:20:18 CST 2025