Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import to different tablespace?
Thanks, that's just what I figured out too.
Barry
"TurkBear" <jgreco1_at_mn.rr.com> wrote in message
news:q079bu8j9fg8bms0oeduqi0q45rqhoccn2_at_4ax.com...
> If the tablespace exists it will be used unless you
> revoke UserX's quota on that tablespace -
> you can restore it after the import , if UserX stills needs it...
>
>
>
> "bgt0990" <btighe_at_neometrics.com> wrote:
>
> >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
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Wed Apr 10 2002 - 15:14:18 CDT