Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: import to different tablespace?
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
![]() |
![]() |