Re: Import to wrong tablespace!

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)