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

Re: import to different tablespace?

From: Fritz Tatzri <paladon_at_gmx.net>
Date: Thu, 11 Apr 2002 13:30:16 -0700
Message-ID: <3cb4cafc$0$19168$5039e797@newsreader01.highway.telekom.at>


Hi,

try to set the tablespace offline or read only?

so long
fritzi

"bgt0990" <btighe_at_neometrics.com> wrote in message news:3cb48ed0_1_at_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 Thu Apr 11 2002 - 15:30:16 CDT

Original text of this message

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