Re: Table belongs to Original tablespace after export with DataPump

From: Amir Gheibi <gheibia_at_gmail.com>
Date: Fri, 30 Jan 2009 10:15:49 +0800
Message-ID: <c906cd460901291815k153f56cg97673c8e6258f0ad_at_mail.gmail.com>

Thanks for the reply. But my question is how can I prevent this while importing so I don't have to run another script after that.

On Thu, Jan 29, 2009 at 11:31 PM, David Ballester <ballester.david_at_gmail.com
> wrote:

> Alter table .... modify default attributes tablespace <tablespace >
>
> if this table has partitions, use:
>
> Alter table ... modify default attributes for partition <partition>
> tablespace <tablespace>
>
> HTH
>
> D.
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 29 2009 - 20:15:49 CST