brspace tbreorg fails with ORA-12015: cannot create a fast refresh materialized view from a complex query
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
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...