On Jul 18, 12:49 am, BD <robert.d..._at_gmail.com> wrote:
> I'm on 10.2.0.3 on Win32.
>
> I have some materialized views which were created without the 'USING
> INDEX' clause.
>
> The only provision I had put in that clause (for those MVs which were
> created correctly) was for a separate tablespace for the indexes.
>
> I have located the "I_SNAP$_" indexes for the MVs - specifically,
> those that are in an incorrect tablespace.
>
> Is there a risk in relocating these indexes to the correct tablespace
> with a standard 'ALTER INDEX REBUILD' statement?
>
> The only other option I see is to drop and recreate the MV, which is
> not appealing because some of them are over 1GB in size. Hopefully a
> quick 'gen' script to create a series of ALTER INDEX REBUILD
> statements is all I'll need...
>
> Thanks,
>
> BD
Please show your current create statement, I do not get what you mean
by the 'provisioning' sentence.
Also see http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6002.htm#i2147304.
Experiment with a bogus mview until you may get it right, using using
index I assume. I recommend to follow the documentation and not to
touch the underlaying technical objects directly, unless explicitly
supported.
Regards, Erik Ykema
Received on Thu Jul 19 2007 - 01:51:03 CDT
