ora-1950 on import

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 15 May 2008 13:33:34 GMT
Message-ID: <OYWWj.36805$Au2.31033@trnddc07>

What would cause this? I am exporting data from schema S1 in database D1, and importing into schema S2 in database D2. In S1, everything is in the USERS tablespace. I set up the default tablespace in S2 to be TS2, grant unlimited quota on TS2 and no quota on USERS. S2 btw is starting out empty. Out of 100 tables, 96 of them correctly loaded into tablespace TS2, however on 4 of them I got ora-1950 - no privileges on tablespace 'USERS'. Why? Received on Thu May 15 2008 - 08:33:34 CDT

Original text of this message