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 -> Change of tablespace

Change of tablespace

From: andy <news_at_info-line.it>
Date: Thu, 25 Oct 2001 08:50:51 GMT
Message-ID: <3bd7d1a2.5432261@news.cis.dfn.de> 





On Oracle 7.3.4 i have created a user and load data on it. His
tablespace is called TB1.


I would like to load his data to another tablespace TB2.
Making an export, drop the user, recreate user with new TB2 default
tablespace, load data. Data will be load on TB1 tablespace.
The only way is delete TB1 tablespcae before loading data?



Thanks in advance.



Andy.
Received on Thu Oct 25 2001 - 03:50:51 CDT












Original text of this message













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