Home » RDBMS Server » Server Administration » Local and Global indexes in oracle (Oracle 10g)
Local and Global indexes in oracle [message #380485] Mon, 12 January 2009 01:08 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Any one tell whether can we see the particular table or table partition and the index partition is local or Global
i have tried using the below query

select * from user_ind_partitions;

select * from user_tab_partitions;


but i cannt find it can any one help on this

Thanks,
Re: Local and Global indexes in oracle [message #380495 is a reply to message #380485] Mon, 12 January 2009 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user_part_indexes.locality

Regards
Michel
Re: Local and Global indexes in oracle [message #380542 is a reply to message #380495] Mon, 12 January 2009 04:28 Go to previous message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member

Thanks Michel for u kind reply
Previous Topic: forget my user id and password what to do ?
Next Topic: how to refresh v$session with out kill session
Goto Forum:
  


Current Time: Mon Dec 05 19:00:25 CST 2016

Total time taken to generate the page: 0.17134 seconds