Re: **ALERT** Serious Oracle 8.1.7 MTS bug

Five steps to go... if not on ORACLE 8i or higher...

In 8i or higher you can use MOVE...

1. create table with similar structure and required storage parameters in another tablespace.. and then
2. Insert into <new table> from the old table...
3. Check the containts of NEW and OLD Table..
4. Drop the old table..
5. Rename the new table to old_table_name...

Anyway.. during rebuilding indexes also.. you need double the space.. right ??

Any corrections or suggestions ??

HTH... Nikunj

• Original Message ----- From: "Raj Gopalan" <raj.gopalan_at_netdecisions.co.uk> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, November 09, 2000 05:55 AM Subject: RE: Alter table rebuild .... ?

> You need to recreate the tables to achive this.
>
> -----Original Message-----
> Sent: Thursday, November 09, 2000 1:02 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear gurus !
> Is there anything similar to "alter index MY_INDX rebuild ..... " for
tables
> ?
> I need to move a table from one TBS to another ...
>
> TIA
>
>
> Andrey Bronfin
> Navixo.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Raj Gopalan
> INET: raj.gopalan_at_netdecisions.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 10 2000 - 00:37:42 CST