Oracle Database Discussions

Hi,
When defininging materialized views, our modeling tool (ERwin) does not support the USING INDEX TABLESPACE clause of the CREATE MATERIALIZED VIEW statement. It does have, however, have a rudimentary scripting capability that would allow us to add an "ALTER MATERIALIZED VIEW" statement later on.

My thought was, I could let the tool generate the DDL to create the view and then cobble together a macro to add the index tablespace specifications. However, it looks as though Oracle 10gR2 does not support "ALTER MATERIALIZED VIEW mvname USING INDEX TABLESPACE" syntax.

Can someone please verify whether or not I correct in this assessment? And if not, is there some other method of changing the index tablespace for a MV?