Title: RE: HP-UX 11/8.1.6.x/Index-Organized Tables
Create as/Alter table rename prod to backup/Alter table rename new to prod/
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 7:31 AM
To: Multiple recipients of list ORACLE-L
ALTER TABLE ... MOVE
HTH
Tim
-Original Message-
Sent: Friday, January 18, 2002 10:31 AM
To: Multiple recipients of list ORACLE-L
Hey all...I have to do some reorgs of some malformed IOTs (Index-
Organized Tables) in one of my databases. ALTER INDEX ... REBUILD
doesn't work, on the IOT
can't you
create table parallel 5 nologging as select /*+ parallel(iot 5)
*/ * from iot
Then
Truncate your IOT
Then
Make sure the the IOT has nologging
insert --+ append
into IOT
select --+ enable parallel here
*
from
-Original Message-
Sent: Friday, January 18, 2002 1:21 PM
To
Hi, Mike,
ALTER TABLE ... MOVE TABLESPACE ...;
rebuilds IOT's PK.
HTH
Vadim
-Original Message-
Sent: Friday, January 18, 2002 10:31 AM
To: Multiple recipients of list ORACLE-L
Hey all...I have to do some reorgs of some malformed IOTs (Index-
Organized Tables) in one of my databases. A
Sigh. I was afraid of that. Any other ideas?
---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304
-Original Message-
Sent: Friday, January 18, 2002 9:44 AM
To: Vergara; Michael (TEM); Multiple