Re: Moving Objects from One Tablespace to Another

2004-01-07 Thread N.Anand Kumar
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).


Re: Moving Objects from One Tablespace to Another

2004-01-07 Thread Mladen Gogala
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).