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,

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 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 16:58:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.