Home » SQL & PL/SQL » SQL & PL/SQL » Data Dictionary
Data Dictionary [message #423550] Fri, 25 September 2009 04:59 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #423561 is a reply to message #423559] Fri, 25 September 2009 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Maybe the cause is that you didn't execute a create index statement.

Regards
Michel
Re: Data Dictionary [message #423562 is a reply to message #423559] Fri, 25 September 2009 05:45 Go to previous message
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.
Previous Topic: Case When statement in Insert statement
Next Topic: Substr weirdness
Goto Forum:
  


Current Time: Sat Feb 08 19:18:07 CST 2025