| ALL_TABLES is showing incorrect information [message #273965] |
Fri, 12 October 2007 07:12  |
Pastonp
Messages: 13
Registered: November 2006
|
Junior Member |
|
|
Hi ,
Has anyone come accross the following senario under 10.2.0.3.0 and has any idea what may be causing it ?
Some User tables not showing in all_tables or all_objects but do appear in the dba_ user_ eqivalents.
Some user tables that have been deleted and purged appearing in all_tables and all_objects but not in dba_ and user_ eqivalents.
Just ordinary tables - eg create table fred as select * from dual - nothing strange.
Thanks
P
[Updated on: Fri, 12 October 2007 07:43] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: ALL_TABLES is showing incorrect information [message #274145 is a reply to message #274144] |
Sun, 14 October 2007 11:28  |
Pastonp
Messages: 13
Registered: November 2006
|
Junior Member |
|
|
| Michel Cadot wrote on Sun, 14 October 2007 12:05 |
No explaination until you post what you did.
Regards
Michel
|
Whats to explain ?
What part of this very simple question do you not understand ?
If you need me to explain how to select records from all_tables or user_tables then you are unkilely to be able to help me with my question.
Suggest you let someone who does understand reply and stop being very intentianlly difficult and rude.
P
|
|
|
|
| Re: ALL_TABLES is showing incorrect information [message #274146 is a reply to message #274145] |
Sun, 14 October 2007 11:40 |
 |
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: |
stop being very intentianlly difficult and rude.
|
Rude? What is rude? I just said I can't give any explaination until you post what you did.
How many times I saw people saying what they said is what they did and when they finally post what they did we see this is not what they said? I can't count them.
In addition, you gave an interpretation of what you got but are you sure this is the correct one?
So post what you did and what you get.
Regards
Michel
[Updated on: Sun, 14 October 2007 11:45] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: ALL_TABLES is showing incorrect information [message #274278 is a reply to message #274270] |
Mon, 15 October 2007 05:41 |
Pastonp
Messages: 13
Registered: November 2006
|
Junior Member |
|
|
Hi ,
for the benefit of those who are interested in what caused this situation i will try to explain...
When using sql developer a user noticed that sql developer refused to show the DDL for some tables. It appeared at first sight to be a bug but i was more concerned when the user got a different list of tables when running a select * from all_tables where owner = USER select * from user_tables
I was unable to recreate the problem.
In the end it turned out that the user had created his own copy of all_tables and all_objects. These were overriding the public synonyms of all_tables and all_objects.
Renaming or deleting the Users tables called all_tables etc resolved the issue.
not sure why sql developer does not explicity refer to the public synonyms but that is a question for another day. I will send a bug report as the sql developer team might be interested to know of this behaviour.
Regards
P
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
