OraFAQ Forum: Server Administration » Local and Global indexes in oracle

Home » RDBMS Server » Server Administration » Local and Global indexes in oracle (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Local and Global indexes in oracle [message #380485]

Mon, 12 January 2009 01:08

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,

Report message to a moderator

Re: Local and Global indexes in oracle [message #380495 is a reply to message #380485]

Mon, 12 January 2009 01:29

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

user_part_indexes.locality

Regards
Michel

Report message to a moderator

Re: Local and Global indexes in oracle [message #380542 is a reply to message #380495]

Mon, 12 January 2009 04:28

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Thanks Michel for u kind reply

Report message to a moderator

Previous Topic:	forget my user id and password what to do ?
Next Topic:	how to refresh v$session with out kill session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 02 09:18:34 CDT 2026