Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Moving objects to a different tablespace using imp/exp

Moving objects to a different tablespace using imp/exp

From: Steve <slee1_at_nospam.email.com>
Date: Fri, 29 Jan 1999 04:31:28 GMT
Message-ID: <AQas2.6123$q57.4746@news.rdc1.bc.wave.home.com> 





I am trying to move objects owned by SCOTT out of the SYSTEM tablespace to 
another tablespace (USER) using imp/exp but the objects keep geting created in 
the SYSTEM tablespace.


I did a imp scott/tiger show=y and all the create table statements have 
"TABLESPACE SYSTEM" at the end. 


How do I move SCOTT's objects (and other non-SYSTEM objects put in there by 
inadvertently) out of the SYSTEM ? 


Thanks for your help 


Steve

Received on Thu Jan 28 1999 - 22:31:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US