Re: Import table in Different Tablespace

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Thu, 21 Oct 1999 11:39:32 GMT
Message-ID: <7umu1i$roh$1@nnrp1.deja.com>

In article <7um32b$an7$1_at_coco.singnet.com.sg>, "Ciem Mehta" <chittesh_at_swi.com.sg> wrote:
> Hi,
>
> I am trying this thing with version 8.0.5
>
> I want to import the list of tables in the different tablespace
> from actually it was exported.
>
> Even when I change the default tablespace for the user still
> it asks for the same Tablespace.
>
> Even I tried with ignoring creation error but it won't work as
> table creation it self gives error while doing import
>

I think that you can pre-create the tables in the tablespace that you want (with the approprite storage clause), then run the import. It will complain that the tables already exist, but will work...(I think)

Another thing that "may" work is editing the dump file and changing the tablespace name.

Suck it an see I reckon!

Cheers
Tony Adolph
> Any help will be highly appriciated..
>
> Thanks
>
> - Chittesh Mehta
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 06:39:32 CDT