RE: RAC and LMT

From: srinivasan v <srini_at_comline.com.my>
Date: Fri, 21 May 2004 15:13:18 +0800
Message-ID: <000901c43f03$18750330$6fc809c0@comline.com.my>

Hi
Sorry if i digress.
I know we can "alter index .. rebuild" online and tried out rebuilding all indexes of a schema into another tablespace. Some users were using the system.
A few indexes became "UNUSABLE".Dropped and recreated after asking users to logout.OK.
Was wondering what may be the cause for it.

9.2.0.1.0 on Win2k.

regards,

Srinivasan

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Pete Sharman Sent: Friday, May 21, 2004 2:52 PM
To: oracle-l_at_freelists.org
Cc: Peter Ross Sharman
Subject: RE: RAC and LMT

And to amplify back again ... :)

You can move tables online, provided they're IOT's. If not, normal tables = can be moved pretty much online using DBMS_REDEFINITION. One stage require= s a lock for a brief time, but that's all.

Pete
=

"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
=

"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] = On Behalf Of Tim Gorman
Sent: Friday, 21 May 2004 4:43 PM
To: oracle-l_at_freelists.org
Subject: FW: RAC and LMT

To amplify Mr Sharman's reply...

  ALTER TABLE <table-name> MOVE
    [ PARTITION <part-name> | SUBPARTITION <subpart-name> ]     TABLESPACE <new-LMT>
    PARALLEL <as-much-as-you-can-stand>
    NOLOGGING; Moving ONLINE is available only for indexes, unfortunately. And doing the former (ALTER TABLE ... MOVE) will absolutely require the latter (ALTER INDEX ... REBUILD).   ALTER INDEX <index-name> REBUILD
    [ PARTITION <part-name> | SUBPARTITION <subpart-name> ]     TABLESPACE <new-LMT>
    PARALLEL <as-much-as-you-can-stand>
    [ ONLINE ]
    NOLOGGING COMPUTE STATISTICS; A great way to exercise the heck out of your disk drives, too...

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 Fri May 21 2004 - 02:04:59 CDT