Re: exporting multiple tablespaces then importing to single tablespace

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 11 May 2005 08:57:08 +0200
Message-ID: <26b381pkhtqs15jh3utuldem1g5i86m24d@4ax.com>

On Mon, 09 May 2005 23:27:24 GMT, "Kee" <keedae_at_hotmail.com> wrote:

...
>I am facing a problem where the user joe has more than one table spaces.
>Above case as joe's tablespace set to A only. What if joe has tablespace A,
>B, C, D and E and wants to move all data to tablespace Z? Everytime I do
>that, I get this Tablespace A, B, C, D, E are not available. Also for
>following the following steps
>http://www.oracle.com/technology/oramag/oracle/02-jul/o42support.html to use
>SQL script doesn't work nicely due to constraints on tables and Index file
>reports some errors on syntaxes created by import utility.
>
>
>
>

Are tablespaces A to E still present or have you dropped them? If so, recreating them temporarily (with a small size), do the import and then remove them, would that help?

Jaap. Received on Wed May 11 2005 - 01:57:08 CDT