on 03-05-2010 5:30 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Read Note 741478 - FAQ: Materialized views, specially under point 12.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.