Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: import to different tablespace?
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
![]() |
![]() |