Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

brspace tbreorg fails with ORA-12015: cannot create a fast refresh materialized view from a complex query

Hi all

I tried to run a table reorg using the following command last night:

brspace -u / -c force -f tbreorg -a long2lob -t TST03 -NBR -e 88 > TST03_reorg.log

This has worked successfully for other tables in the system.

However, I got the following error:

BR0301E SQL error -42008 at location tab_onl_reorg-39, SQL statement:

'BEGIN DBMS_REDEFINITION.START_REDEF_TABLE (UNAME => '"SAPS1P"', ORIG_TABLE => '"TST03"', INT_TABLE => '"TST03#$"', COL_MAPPING => '"DCLIENT" "D

CLIENT", "DNAME" "DNAME", "DPART" "DPART", "DROWNO" "DROWNO", "DDATALEN" "DDATALEN", TO_LOB("DCONTENT") "DCONTENT"', OPTIONS_FLAG => DBMS_REDEFI

NITION.CONS_USE_ROWID); END;'

ORA-42008: error occurred while instantiating the redefinition

ORA-12015: cannot create a fast refresh materialized view from a complex query

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: 2013-01-23 19.12.34

BR0640I SQL statement waiting for busy resource:

'ALTER TABLE "SAPS1P"."TST03" PARALLEL 1'

ORA-00054: resource busy and acquire with NOWAIT specified

BR0280I BRSPACE time stamp: 2013-01-23 19.16.36

BR1106E Reorganization of table SAPS1P.TST03 failed

Now, I did half expect the "busy resource" error as SAP was still running and this is an exceptionally busy test system.

But the other errors come BEFORE this. Are they just red herrings - i.e. if I ran this with SAP down might this work? (this isn't something I can just simply test due to rare outage schedules). I need to know that it will work with SAP down (especially as it'll be my colleague running it as I will be away on holiday!).

All I can find for ORA-12015 talks about changing the DDL commands but obviously I can't do this, it's generated by brconnect...

Thanks

Ross

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question