| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Move table online and update the indexes at the same time.
We've done what Tanel suggests as the Pre-Oracle 9i. you just need a lot
more disk, some code and a rename table. Lot easier in DW though.
=09
You need to do a big alter or something?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Tanel P=F5der
Sent: Monday, July 26, 2004 4:34 PM
To: oracle-l_at_freelists.org
Subject: Re: Move table online and update the indexes at the same time.
> Hi all,
> We need to rebuild our table and index segments. I guess we wouldn't have
> problems rebuilding the indexes online. However, I don't see any way to
> move tables online. Of course, I can issue ALTER TABLE ... MOVE ONLINE,
> but this would invalidate all indexes of the table. I will have to rebuild
Oracle 10g: alter table shrink space cascade
Oracle 9i: dbms_redefinition package
Pre-Oracle 9i: custom mechanism, cloning table and recording changes with
triggers or snapshot logs.
Tanel.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination,=20 distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Jul 26 2004 - 17:58:50 CDT
 |
 |