When altering refresh time for a materialized view, the following error occurs
"ORA-02221: invalid MAXEXTENTS storage option value"
When doing 'Show SQL' for the change it shows the following:
ALTER MATERIALIZED VIEW TEST_NEXT_REFRESH
STORAGE ( MAXEXTENTS 0 );
ALTER MATERIALIZED VIEW TEST_NEXT_REFRESH
REFRESH FAST
ON DEMAND
START WITH TO_DATE('22-Dec-2010 11:00:00','dd-mon-yyyy hh24:mi:ss')
NEXT trunc(sysdate) + 1
WITH ROWID;
The additional
ALTER MATERIALIZED VIEW TEST_NEXT_REFRESH
STORAGE ( MAXEXTENTS 0 );
is incorrect.
WORKAROUND
Make the required changes
Click 'Show SQL'
Click 'Send to Editor'
Remove the following:
ALTER MATERIALIZED VIEW <mv name>
STORAGE ( MAXEXTENTS 0 );
Execute in the Editor
STATUS
Waiting for fix in a future release of Toad for Oracle
