Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: Move objects from one tablespace to another

Re: Move objects from one tablespace to another

From: srivenu <srivenu_at_hotmail.com>
Date: 26 Feb 2002 20:57:13 -0800
Message-ID: <1a68177.0202262057.37b9c045@posting.google.com>

You can use
alter table .. move tablespace ...

But you have to rebuild the indexes on the tables after you do this Received on Tue Feb 26 2002 - 22:57:13 CST

This message: [ Message body ]
Next message: RFre465789: "Re: oracle 8i upgrade exam"
Previous message: JB: "Re: Can an account login with either "/" or username/password?"
In reply to: Philip Morrow: "Move objects from one tablespace to another"
Next in thread: Peter Sylvester: "Re: Move objects from one tablespace to another"

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