Re: ORA-03217 ALTER TABLESPACE TEMP PERMANENT; 9.2

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: 2 Dec 2004 11:46:16 -0800
Message-ID: <d4d6f278.0412021146.2bed5139@posting.google.com>

Sounds like you have some objects in the database you are migrating from that are in the TEMP tablespace. Not recommended but I guess that's where you are currently.

How many objects are in TEMP? Can you move them out of TEMP to a more "usual" tablespace. That should fix your export/import problem.

In 9.2 an alternate approach that "might" work would be to create a different temporary tablespace named TEMP2, then ditch TEMP, recreate TEMP as a permanet tablespace. But that just perpetuates a problem that should be fixed. Received on Thu Dec 02 2004 - 13:46:16 CST