Re: Moving Objects from One Tablespace to Another

From: N.Anand Kumar <anand_at_fps.itwsignode.co.in>
Date: Wed, 07 Jan 2004 02:19:26 -0800
Message-ID: <F001.005DBF9B.20040107021926@fatcity.com>

This works well in ver 8 or higher how do we do in Oracle 7 version.

Anand Kumar
ITW Signode India Ltd

Original Message ----- To: LazyDBA.com Discussion Sent: Wednesday, January 07, 2004 1:50 PM

alter table emp move tablespace tbs2;
Deepa Kale -DBA
Jyoti Structures - Nasik(IT)

                      "Vikas Sharma"
                      <vikassharma_at_gail        To:       "LazyDBA.com
Discussion" <oracledba_at_lazydba.com>
                      .co.in>                  cc:
                                               Subject:  Moving Objects from
One Tablespace to Another
                      01/07/2004 01:07
                      PM

How do I move my objects (say Tables) from One Tablespace to Another without the need to recreate them?

Regards,

Vikas Sharma

Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com By using this list you agree to these terms: http://www.lazydba.com/legal.html

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: N.Anand Kumar
INET: anand_at_fps.itwsignode.co.in

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Wed Jan 07 2004 - 04:19:26 CST