Home » SQL & PL/SQL » Client Tools » Cannot see list of tables in PL/SQL Developer (PL/SQL DEveloper 8.01.1502 Oracle 11g)
Cannot see list of tables in PL/SQL Developer [message #442045] Thu, 04 February 2010 09:39 Go to next message
sportsman31
Messages: 3
Registered: February 2010
Junior Member
Hi
I'm having a weird problem. I can do any sql commands against the schema I want (PSUSYS) with my username(SCHWAN) in the sql window, but when I want to export a table(created with a different schema) no tables are listed in the export window. This does work for my coworkers with the same access.
At one time this used to work so I'm wondering if it is a parameter that I inadvertently changed. Anyone have any thoughts?
Re: Cannot see list of tables in PL/SQL Developer [message #442050 is a reply to message #442045] Thu, 04 February 2010 09:49 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you using the Export User Objects menu item or the Export Tables menu item?
As far as I can see User Objects lets you specify a schema whereas Tables only ever gives the current schema.
Re: Cannot see list of tables in PL/SQL Developer [message #442053 is a reply to message #442050] Thu, 04 February 2010 09:55 Go to previous messageGo to next message
sportsman31
Messages: 3
Registered: February 2010
Junior Member
I am using the Export Tables menu item. I also thought it only works for the current schema but it does work for my coworkers.
Re: Cannot see list of tables in PL/SQL Developer [message #442063 is a reply to message #442045] Thu, 04 February 2010 10:35 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Really not sure how. Since there is no way of specifying a schema and the list of tables doesn't display owner I really don't see how it could ever be for anything other than current schema. After all if you've got two tables with the same name in different schemas how would you tell them apart?
Unless they've got a newer version of PL/SQL developer than you and I do which does allow multiple schemas.
Re: Cannot see list of tables in PL/SQL Developer [message #442104 is a reply to message #442063] Thu, 04 February 2010 12:47 Go to previous messageGo to next message
sportsman31
Messages: 3
Registered: February 2010
Junior Member
I found my answer. It was a parameter I had changed at one time. In preferences, under user interface, object browser I changed the default user selection to all users and now all the tables will show up.
Re: Cannot see list of tables in PL/SQL Developer [message #442108 is a reply to message #442045] Thu, 04 February 2010 13:40 Go to previous message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
thanks for the feedback
Previous Topic: sp2-0310
Next Topic: Oracle issue after install ODBC
Goto Forum:
  


Current Time: Mon Sep 26 16:18:05 CDT 2016

Total time taken to generate the page: 0.12059 seconds