Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQl Developer not fetching the latest database updates

988405Jan 31 2013 — edited Feb 4 2013
Hi ,

I started SQL Developer just recently.

I had a connection file which I imported to connect to my oracle server .

I am encountering a weird Problem. I am unable to retrive any update done to the DB.

For example,

My DB server to which i connect has say 50 rows in a table , the day I connected to DB.

I am able to see all the details of those 50 rows details.This is fine.

Say today I added one more row .

I am unable to get the details of the row 51 which I added recently.

Please help and bear with my wordings.

Thanks
Ramesh

Comments

Gary Graham-Oracle

You do not say which version of SQL Developer is in use, which JDK, which OS, whether Thin or OCI/Thick JDBC driver, etc., etc.  However, assuming recent versions not subject to old, known bugs, you may just need to read this blog post...

http://www.thatjeffsmith.com/archive/2013/03/why-cant-i-see-my-tables-in-oracle-sql-developer/

1 person found this helpful
2933934

Thank you, Gary.

I updated the post with the version info. I did not explicitly install this JDBC driver, so whatever the OSD came with?  Unless it is using whatever is installed on my machine, in which case would be the thin driver.

I did check out that post, and I appreciate you sharing it. I did click the 'include synonyms' filter, but behavior remained unchanged.

I would prefer to use OSD, and that is what our dev team was expecting to use, but we just can't see the information.  We are using an ID that does not 'own' those tables, per se.  But, why would DBVisualizer show these tables, when OSD does not?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 4 2013
Added on Jan 31 2013
#sql-developer
3 comments
85 views