dbms_redefinition using rowid and system tablespace
From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Thu, 29 Mar 2012 13:05:27 +0200 (CEST)
Message-ID: <57147.213.162.65.111.1333019127.bloek_at_pwebmail4.utanet.at>
Hello List,
Date: Thu, 29 Mar 2012 13:05:27 +0200 (CEST)
Message-ID: <57147.213.162.65.111.1333019127.bloek_at_pwebmail4.utanet.at>
Hello List,
this is 11.2.0.2.0 Solaris
dbms_redefinition with options_flag => DBMS_REDEFINITION.CONS_USE_ROWID
Does enybody get through to avoid the creation of the unique index on M_ROW$$ in SYSTEM tablespace?
Trace 10046 show this statement:
CREATE UNIQUE INDEX "owner"."I_SNAP$_table_name_changed" ON "owner"."table_name_changed$REORG" ("M_ROW$$") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE "SYSTEM" I don't see any clue in documentation and there is a not answered thread in OTN to this topic, so I have little hope. Anyway I want get some feedback before increasing the system tbs.
thanks
Jaromir D.B. Nemec
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 29 2012 - 06:05:27 CDT