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: bgt0990 <btighe_at_neometrics.com>
Date: Wed, 10 Apr 2002 16:14:18 -0400
Message-ID: <3cb49dec_3@corp-news.newsgroups.com>


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

Original text of this message

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