Cannot see list of tables in PL/SQL Developer [message #442045] |
Thu, 04 February 2010 09:39  |
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 #442063 is a reply to message #442045] |
Thu, 04 February 2010 10:35   |
cookiemonster
Messages: 13963 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.
|
|
|
|
|