"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
news:3EAAE701.888DA97A_at_exxesolutions.com...
> Randy Harris wrote:
>
> > "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 Harris
>
> Yes. And it is a good idea to always grant 0 on the system tablespace to
> everyone except SYS and SYSTEM.
>
> BTW: Does anyone know why it is that when Oracle installs it thinks SYSTEM
is a
> temporary tablespace for the SYSTEM schema? This has always struck me as
quite
> strange. Oracle builds a rollback segment in the SYSTEM tablespace and
this I
> understand. But why not a small temp tablespace to serve the same purpose
rather
> than configuring it as it does?
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> (remove one 'x' from my email address to reply)
>
Please forgive my slowness. How do I "grant 0 on system"? I tried ALTER
USER CM QUOTA 0 ON SYSTEM, but unless I revoke RESOURCE his objects keep
ending up in SYSTEM.
Received on Sat Apr 26 2003 - 20:45:59 CDT
