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