Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: User default directories using imp
"Frank" <fvanbortel_at_netscape.net> wrote in message
news:3EAA9DB6.2090402_at_netscape.net...
> Randy Harris wrote:
> > Is there any way to
> >
> >>get imp to restore tables to the user's default rather than the source
> >>tablespace?
> >>
> If you knew that beforehand, you could have created
> the user with the correct default tablespace, revoke unlimted
> tablespace (user gets it with the resource role), and grant
> quota on default (and other) tablespaces. Explicitely do
> a grant 0 on system.
> The import (ignore=y), and the import will use the user's default
> tablespace.
>
>
> --
> Regards, Frank van Bortel
>
Can I grant unlimited quota on his default tablespace and 0 on system? And if so, that would then force his objects to get created in his default? (I have to do the import again for the production roll out)
Thanks for your help
-- Randy HarrisReceived on Sat Apr 26 2003 - 15:24:52 CDT