You are create for all partitioned table an index because you give the word 'local' on.

Index offer a table, which is partitioned.( offer all):

create
on (col1, col2,...);




Index of each patitioned tablepart:

create
on
(col1, col2,...)
local;



Index has an own partitioned methode independent of the table

create
on
(col1, col2,...)
global index by range (col)
partition p1 values less than 500,
partition p1 values less than 2500
....


I hope you have understaand it.

Thomas Schmidt
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules



Click Here to Expand Forum to Full Width