RE: Move table to another tablespace

From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
Date: Thu, 25 Oct 2001 06:45:34 -0700
Message-ID: <F001.003B41FF.20011025055521@fatcity.com>

<SPAN
class=484315212-25102001>Nirmal,
<SPAN
class=484315212-25102001> 
You
need to use import with the indexfile option. Edit the file created at this step to change the location of the tablespace, run this file against the DB to create the objects then import the data with ignore=y. <SPAN
class=484315212-25102001> 
<SPAN
class=484315212-25102001>Lee 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Nirmal Kumar Muthu Kumaran   [mailto:NIRMALK_at_qtel.com.qa]Sent: 25 October 2001   14:25To: Multiple recipients of list ORACLE-LSubject:   RE: Move table to another tablespace
  hi...
  can you give the exact steps for ur
  2nd option.
  1)exp scott/tiger tables=emp,
  2)alter user scott default
  tablespace tools,(before it's users) <FONT color=#0000ff face=Arial   size=2>3)imp scott/tiger fromuser=scott touser=scott   But still oracle imports to users
  tablespace itself. i made
  users tablespace off, before import, that case, i kicked away by an error, as   tablepsace is in offline.
  Expecting your answer.
  Rgds, <FONT color=#0000ff
  face=Arial size=2>Nirmal.,   

    -----Original Message----- <FONT
    face=Arial size=1>From:   <FONT face=Arial     size=1>G.Plivna_at_itsystems.lv [SMTP:G.Plivna_at_itsystems.lv]     Sent:   <FONT face=Arial

    size=1>Thursday, October 25, 2001 3:25 PM <FONT face=Arial 
    size=1>To:     <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
    size=1>Subject:        <FONT 
    face=Arial size=1>Re: Move table to another tablespace 

    above 8.<something> <FONT
    face=Arial size=2>alter table <table_name> move tablespace
<tablespace_name>;

    Or always you can <FONT face=Arial
    size=2>1. export table 2. recreate in     another tablespace 3. import data in     table created in step 2.
    Gints Plivna <FONT face=Arial
    size=2>IT Sist&#275;mas, Mer&#311;e&#316;a 13, LV1050 R&#299;ga <FONT face=Arial     size=2><A href=""
    target=_blank>http://www.itsystems.lv/gints/
<FONT face=Arial

    size=2>                                                                                                                   

<FONT face=Arial

    size=2>                    
    Roland.Skoldbl                                                                                 

<FONT face=Arial

    size=2>                    

    om_at_ica.se           
    To:     Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>      
<FONT face=Arial

    size=2>                    

    Sent
    by:            

    cc:                                                                       

<FONT face=Arial

    size=2>                    

    root_at_fatcity.c      
    Subject:     Move table to another

    tablespace                             

<FONT face=Arial

    size=2>                    
    om                                                                                             

<FONT face=Arial

    size=2>                                                                                                                   

<FONT face=Arial

    size=2>                                                                                                                   

<FONT face=Arial

    size=2>                    
    2001.10.25                               

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Received on Thu Oct 25 2001 - 08:45:34 CDT