O8i - moving materialized views

From: Steve Orr <sorr_at_arzoo.com>
Date: Fri, 9 Jun 2000 15:00:15 -0700
Message-Id: <10523.108486@fatcity.com>

I'm doing a DB reorg and I've successfully moved several materialized views to new tablespaces using "alter materialized view move"... COOL! However, two of the tables, er um, materialized views are producing an ORA-00600... not cool.

SQL> alter materialized view arzoo.TBCAT_REVIEW_LISTS 2 move tablespace v1_arzoo_tbl storage (initial 128K next 128K) ; alter materialized view arzoo.TBCAT_REVIEW_LISTS *
ERROR at line 1:
ORA-00600: internal error code, arguments: [6302], [2], [], [], [], [], [], []

Anyone encounter this? OWS has never encountered this problem before (hmmm...) and wants me to send them test cases with DDL, exports, the whole nine yards... Don't have time for such non-sense today.

Steve Orr
"Slick-on Valley" Received on Fri Jun 09 2000 - 17:00:15 CDT