Skip to Content
0
Former Member
Mar 05, 2010 at 05:30 AM

Table reorganisation

217 Views

Dear All,

I am re-organisation table 'PROW' in my Oracle database.

I created a new table psaprep_archive and stsrted the re-organisation using BRTOOLS

The table PSAPREP_archive has autoextend on.

Now during re-organisation i am getting below error.

BR0280I BRSPACE time stamp: 2010-03-05 10.26.04

BR1101I Starting online table reorganization...

BR0280I BRSPACE time stamp: 2010-03-05 10.26.04

BR1124I Starting online reorganization of table SAPREP.PROW ...

BR0280I BRSPACE time stamp: 2010-03-05 10.43.06

BR0301E SQL error -12008 at location tab_onl_reorg-20, SQL statement:

'BEGIN DBMS_REDEFINITION.START_REDEF_TABLE (UNAME => '"SAPREP"', ORIG_TABLE => '

"PROW"', INT_TABLE => '"PROW#$"', OPTIONS_FLAG => DBMS_REDEFINITION.CONS_USE_PK

); END;'

ORA-12008: error in materialized view refresh path

ORA-01653: unable to extend table SAPREP.PROW#$ by 131072 in tablespace PSAPREP_

ARCHIVE

ORA-06512: at "SYS.DBMS_REDEFINITION", line 50

ORA-06512: at "SYS.DBMS_REDEFINITION", line 1343

ORA-06512: at line 1

BR0280I BRSPACE time stamp: 2010-03-05 10.43.08

BR1106E Reorganization of table SAPREP.PROW failed

BR0280I BRSPACE time stamp: 2010-03-05 10.43.08

BR1141I 1 of 1 table processed - 1504064000 of 1504064000 rows done

BR0204I Percentage done: 100.00%, estimated end time: 10:43

BR0001I **************************************************

BR0280I BRSPACE time stamp: 2010-03-05 10.43.09

BR1102I Number of tables reorganized successfully: 0

BR1103E Reorganization failed for 1 table

BR0280I BRSPACE time stamp: 2010-03-05 10.43.09

BR1104E Reorganization failed for all tables

Please help me in correcting the error.

Regards

Tushar