cancel
Showing results for 
Search instead for 
Did you mean: 

Table reorganisation

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

ashutosh_mishra4
Participant
0 Kudos

Hi Sandeep,

I am also facing same issue as described in above that described by You.

Can you help me how you resolve your issues.

Thanks

Ashutosh Kr

Former Member
0 Kudos

Dear Vijay,

Please help me in seting maxextents to unlimited for

table SAPREP.PROW#$

Tablespcae psaprep_archive

Tablespace owner saprep

Please let me know the sql command for this

Thanks and regards

Sandeep

JPReyes
Active Contributor
0 Kudos

You can use brtools for that, did you read the Note?

Regards

Juan

ashutosh_mishra4
Participant
0 Kudos

Hi Juan,

I am also facing same issue as described in above that described by Mr Sandeep.

And i read your given Note number also,and i checked the Point 12,and as per that point i checked the MAXEXTENTS its saved as UNLIMITED.And my redo log is also 200GB.and table also containg Primary key.

But still i am facing the same issue as bescribed in above points.

Please guide me how to resolve this issue,because same issue i am getting for two more tables like GLPCA,ACCTIT.

Thanks

Ashutosh Kr

JPReyes
Active Contributor
0 Kudos

Read Note 741478 - FAQ: Materialized views, specially under point 12.

Regards

Juan

Former Member
0 Kudos

Hi Sandeep,

The SQL error -12008 relates to materialized views. Its not used in SAP context but when it is implicitly used in case of online reorganization using BRSPACE. This issue mainly happens with table owner's default tablespace. All implicit objects are created in this default tablespace which causes overflows and MAXEXTENTS problems.

Ensure that there is sufficient free space available in the table owner's default tablespace, and that problems relating to MAXEXTENTS can be avoided (such as by setting MAXEXTENTS -> UNLIMITED).

Hope this helps.

Thanks & Regards,

Viju