"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1070459892.626206_at_yasure...
> Niall Litchfield wrote:
>
> > Johnny must have either the unlimited tablespace privilege (a bad thing)
or
> > a quota on FRANKTBS allowing his objects to be created there. If you
don't
> > allow him to create objects there 'alter user johnny quota 0 on
franktbs;'
> > and import with ignore=y then the objects will get created where you
want
> > them.
>
> And check too that for all of 'your' schemas you also have QUOTA 0 on
> the SYSTEM tablespace too.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Thanks to all of you.
Bye!
Received on Wed Dec 03 2003 - 10:40:27 CST
