RE: Move table online and update the indexes at the same time.
- From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Jul 2004 17:58:26 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Tanel P=F5der
Sent: Monday, July 26, 2004 4:34 PM
To: oracle-l@xxxxxxxxxxxxx
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
