Data Dictionary [message #423550] |
Fri, 25 September 2009 04:59  |
Srinandini
Messages: 13 Registered: November 2008
|
Junior Member |
|
|
Hi
I queried the DD all_indexes to find if there is an index created on any columns of a particular table
I could not find any rows
Does this mean that theere is no index created on any col of the table?
In other words how do the Data Dictionary tables get populated?
Is it done automatically? or manual process?
Thanks
Sri
|
|
|
Re: Data Dictionary [message #423552 is a reply to message #423550] |
Fri, 25 September 2009 05:12   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
DD is populated automatically.
If there are no records for a given table in all_indexes then either:
1) You do not have any privileges on that table (All_tables only shows you about tables that you can select from)
or
2) There are no indexes on that table
|
|
|
Re: Data Dictionary [message #423559 is a reply to message #423552] |
Fri, 25 September 2009 05:34   |
Srinandini
Messages: 13 Registered: November 2008
|
Junior Member |
|
|
Thanks for the info
Is there any way by which i can find out the cause(index not created/previlege issue)?
Any clues will be helpful
Thanks in advance
Sri
|
|
|
|
Re: Data Dictionary [message #423562 is a reply to message #423559] |
Fri, 25 September 2009 05:45  |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Run your query from an account that has DBA priviliges, and query DBA_INDEXES.
That will show you evertything in the system.
Alternatively, you could see if the user that you are running the query as can select from the table in question.
|
|
|