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 -> import to different tablespace?

import to different tablespace?

From: bgt0990 <btighe_at_neometrics.com>
Date: Wed, 10 Apr 2002 15:09:49 -0400
Message-ID: <3cb48ed0_1@corp-news.newsgroups.com> 





if I export from schema X  as owner X



and want to import to schema Y as user/password file=x.dmp fromuser=X
touser=Y



Is there any way to keep the import from trying to put the tables into the
original tablespaces?  I'ld like them to go into the default tablespace for
user Y but they want to go into X's tablespace.



Thanks for the help


Barry
Received on Wed Apr 10 2002 - 14:09:49 CDT












Original text of this message













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