Re: Data pump remap_tablespace
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 27 Oct 2015 00:18:18 -0400
Message-ID: <562EFB0A.1050005_at_gmail.com>
On 10/23/2015 05:42 AM, John Dunn wrote:
>
> If I use schemas=myschema and remap tablespace=OLDONE:NEWONE
>
> Will only objects from myschema be loaded into the new tablespace?
>
> I assume so…but want to check.
>
> *John *
>
How about doing a test? Export schema SCOTT and import it back into another tablespace. That little test appears to me more trustworthy than a mailing list.
Date: Tue, 27 Oct 2015 00:18:18 -0400
Message-ID: <562EFB0A.1050005_at_gmail.com>
On 10/23/2015 05:42 AM, John Dunn wrote:
>
> If I use schemas=myschema and remap tablespace=OLDONE:NEWONE
>
> Will only objects from myschema be loaded into the new tablespace?
>
> I assume so…but want to check.
>
> *John *
>
How about doing a test? Export schema SCOTT and import it back into another tablespace. That little test appears to me more trustworthy than a mailing list.
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 27 2015 - 05:18:18 CET