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"
<[EMAIL PROTECTED] To: "LazyDBA.com
Discussion" <[EMAIL PROTECTED]>
.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 [EMAIL PROTECTED]
To subscribe: send a blank email to [EMAIL PROTECTED]
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
--------
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 [EMAIL PROTECTED]
To subscribe: send a blank email to [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
