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: TurkBear <jgreco1_at_mn.rr.com>
Date: Wed, 10 Apr 2002 15:12:09 -0500
Message-ID: <q079bu8j9fg8bms0oeduqi0q45rqhoccn2@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:12:09 CDT

Original text of this message

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