Home » SQL & PL/SQL » Client Tools » tables are not getting displayed under schema in sqldeveloper (oracle 11g /Windows 7-32bit )
tables are not getting displayed under schema in sqldeveloper [message #608363] Wed, 19 February 2014 03:28 Go to next message
prejib
Messages: 119
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>
Re: tables are not getting displayed under schema in sqldeveloper [message #608364 is a reply to message #608363] Wed, 19 February 2014 03:31 Go to previous messageGo to next message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
what does
select count(*) from user_tables
give?
Re: tables are not getting displayed under schema in sqldeveloper [message #608365 is a reply to message #608363] Wed, 19 February 2014 03:49 Go to previous messageGo to next message
gazzag
Messages: 276
Registered: November 2010
Location: Bristol, UK
Senior Member
In addition to cookiemonster's question, what does the following give you?

SQL> SELECT * FROM GLOBAL_NAME;
Re: tables are not getting displayed under schema in sqldeveloper [message #608366 is a reply to message #608365] Wed, 19 February 2014 03:56 Go to previous messageGo to next message
prejib
Messages: 119
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)
Re: tables are not getting displayed under schema in sqldeveloper [message #608381 is a reply to message #608366] Wed, 19 February 2014 05:15 Go to previous messageGo to next message
Littlefoot
Messages: 19320
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.
Re: tables are not getting displayed under schema in sqldeveloper [message #608392 is a reply to message #608381] Wed, 19 February 2014 05:55 Go to previous messageGo to next message
prejib
Messages: 119
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>
Re: tables are not getting displayed under schema in sqldeveloper [message #608398 is a reply to message #608392] Wed, 19 February 2014 06:40 Go to previous message
Littlefoot
Messages: 19320
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).
Previous Topic: DEFINE VARIABLES and AMPERSAND
Next Topic: Convertion of text from german to english
Goto Forum:
  


Current Time: Mon Jul 28 14:30:36 CDT 2014

Total time taken to generate the page: 0.09196 seconds