Code:SQL-SSESMADT001-E81ADM0>select index_name, partition_name, tablespace_name from user_ind_partitions; INDEX_NAME PARTITION_NAME TABLESPACE_NAME ------------------------------ ------------------------------ ------------------------------ PARTEMP_PK PARTEMP2 USERS PARTEMP_PK PARTEMP3 USERS PARTEMP_PK PARTEMP4 USERS PARTEMP_PK PARTEMP5 USERS PARTEMP_PK PARTEMP6 USERS PARTEMP_PK PARTEMP1 USERS SQL-SSESMADT001-E81ADM0>alter index partemp_pk rebuild partition partemp2 tablespace tools; Indice modificado. SQL-SSESMADT001-E81ADM0>select index_name, partition_name, tablespace_name from user_ind_partitions; INDEX_NAME PARTITION_NAME TABLESPACE_NAME ------------------------------ ------------------------------ ------------------------------ PARTEMP_PK PARTEMP2 TOOLS PARTEMP_PK PARTEMP3 USERS PARTEMP_PK PARTEMP4 USERS PARTEMP_PK PARTEMP5 USERS PARTEMP_PK PARTEMP6 USERS PARTEMP_PK PARTEMP1 USERS 6 filas seleccionadas.
I think you are joking heh




Reply With Quote