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

Home -> Community -> Usenet -> c.d.o.tools -> How do you change a table's tablespace through Import.

How do you change a table's tablespace through Import.

From: ShengThlick <mrthlick_at_hotmail.com>
Date: 2000/04/13
Message-ID: <kxsJ4.98$I83.983138@dca1-nnrp1.news.digex.net>#1/1 






Hello,



I want to move an existing schema to another database.
However, I want to use different tablespaces for the existing tables rather
than the original ones.



How do I do this?



Wouldn't an Import attempt to place the tables in the same tablespace as the
original database?



I thought I would change the tablespace of the original DBs table, but I
don't think you can change tablespaces and furthermore, wouldn't the
existing data still reside on the former tablespace?



Help.



Thank you
Received on Thu Apr 13 2000 - 00:00:00 CDT












Original text of this message













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