From lerobe@acxiom.co.uk Thu, 25 Oct 2001 06:45:34 -0700
From: Robertson Lee - lerobe <lerobe@acxiom.co.uk>
Date: Thu, 25 Oct 2001 06:45:34 -0700
Subject: RE: Move table to another tablespace
Message-ID: <F001.003B41FF.20011025055521@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: Move table to another tablespace



<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@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@itsystems.lv [SMTP:G.Plivna@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@ica.se            
    To:     Multiple recipients of list ORACLE-L 
    <ORACLE-L@fatcity.com>       
    <FONT face=Arial 
    size=2>                    
    Sent 
    by:             
    cc:                                                                       
    <FONT face=Arial 
    size=2>                    
    root@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.