Re: import to different tablespace?

The questions I saw on google were from people trying to keep the same tablespace name after moving elsewhere, I did not see this particular answer in the 20 some odd that I perused. If you are tired of answering questions in here o mighty Sybrand, don't.

Respectfully
B

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ub97be11a8in10_at_corp.supernews.com...
>
> "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
>
>
Received on Wed Apr 10 2002 - 15:37:53 CDT