You have to apply mig to it. The sooner you do it, the better.
Read database migration guide.
On 2004.01.07 05:19, N.Anand Kumar wrote:
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).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
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).