Database Administration (MOSC)

MOSC Banner

LOB INDEX

edited Jan 28, 2011 11:29PM in Database Administration (MOSC) 6 commentsAnswered
 hi i have a partition  table with below columns

  col3       SYS.XMLTYPE,
  col4       SYS.XMLTYPE,
it seems oracle creates indexes (index_type =Lob) itself.


SEGMENT_NAME                                                                      TABLESPACE_NAME                SEGMENT_TYPE
--------------------------------------------------------------------------------- ------------------------------ ------------------
SYS_IL0000806659C00011$$                                                          USERS                          INDEX PARTITION
SYS_IL0000806659C00011$$                                                          USERS                          INDEX PARTITION



now i want to rebuild this indexes to another tablespace(as we want to drop it's tablespace)
but when i try to rebuilt it i face below error

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-alt:"Calisto MT"; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-alt:"Times New Roman"; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center