Re: Import to wrong tablespace!

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 04 Dec 2003 01:28:45 GMT
Message-ID: <h5wzb.873$zq.439@news01.roc.ny>

"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)
>

Frankly I've never understood why this quota 0 on system is recommended. If a user has unlimited tablespace privilege then quota 0 on system won't do anything? So why bother?

Anurag Received on Wed Dec 03 2003 - 19:28:45 CST