Re: change index in tablespace

From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 8 Dec 1999 01:48:58 GMT
Message-ID: <82kdea$ejl@gap.cco.caltech.edu>

alter index <your_index_name> rebuild
tablespace <your_new_tbs>;

"Robert" Xuequn Xu, Oracle DBA
Caltech, Pasadena, CA 91125

desertflowerln_at_my-deja.com wrote:
: How do I move indexes from one tablespace to another, without
: exporting/importing, in Oracle 7.3.X
: Thanks!

: Sent via Deja.com http://www.deja.com/
: Before you buy.
Received on Tue Dec 07 1999 - 19:48:58 CST

This message: [ Message body ]
Next message: Dave Rawding: "SQL: How to see items from more than one vendor"
Previous message: Thomas Kyte: "Re: Newbie Dynamic SQL Question"
In reply to: desertflowerln_at_my-deja.com: "change index in tablespace"
Next in thread: Paul Bennett: "Index rebuilding (was: change index in tablespace)"
Reply: Paul Bennett: "Index rebuilding (was: change index in tablespace)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US