Moving tables to a different tablespace using exp from 9i and imp into 11gR2

  • From: "Scott W Nelson" <snelson@xxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 29 Jan 2010 14:42:31 -0500

In the past I have changed the owners default tablespace, allocated
quota on the new tablespace, revoked any quota for the old tablespace,
dropped the existing table then done an import of that table and had it
successfully create it in the users new default tablespace.

I can not get this to work importing into 11gR2.  I receive an
ORA-01536: space quota exceeded on the old tablespace.

Datapump seems to not be an option for this as the source of the export
is a 9i database.

Any assistance is greatly appreciated.

Scott Nelson

Other related posts: