Re: import to different tablespace?

"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
>
>

This question has been answered over and over and over and over again. You need to revoke unlimited tablespace from user y and
alter user y quota unlimited on <it's default tablespace>

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address