RE : Datapump question

From: Bertrand Guillaumin <bertrand.guillaumin_at_digora.com>
Date: Wed, 27 Jan 2010 12:37:52 +0100
Message-ID: <7F06EBB9DB1FFD4BB233D8162D0F92572F19C97E2C_at_athena.Digorix2.digora.com>



Hi,
try adding transform=ODI:n to the command. It will force the creation of new oids for the types instead of keeping existing ones.

Best regards,
Bertrand Guillaumin



De : oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] de la part de John Dunn [JDunn_at_sefas.com] Date d'envoi : mercredi 27 janvier 2010 12:28 : venkatramana reddy
Cc : oracle-l digest users
Objet : RE: Datapump question

OK, thanks. It works apart from importing TYPES

ORA-39083: Object type TYPE failed to create with error: ORA-02304: invalid object identifier literal Failing sql is:
CREATE TYPE "PRODUCER20"."TYPE_RET_RESULTS" OID '6C5F28B7ADA6806CE0430A05010C8 06C' as VARRAY(101) of type_ret_result

John Dunn

-----Original Message-----
From: venkatramana reddy [mailto:reddymvr5_at_yahoo.co.in] Sent: 27 January 2010 11:14
To: John Dunn
Subject: Re: Datapump question

Hi John,

Here is the syntax to import data using "impdp";

impdp REMAP_SCHEMA=<fromuser>:<touser> directory=<dir_name> dumpfile=<filename.dmp> logfile=<filename.log>

Regards
Ramana
--- On Wed, 27/1/10, John Dunn <JDunn_at_sefas.com> wrote:

> From: John Dunn <JDunn_at_sefas.com>
> Subject: Datapump question
> To: "oracle-l digest users" <oracle-l_at_freelists.org>
> Date: Wednesday, 27 January, 2010, 4:34 PM
>
>
>
>
>
> Can someone please
> clarify the parameters I need to specify to import all objects from a
> previous datapump export into a different schema from the original.
>
> i.e export was
> from schema1 and I want to import all objects in the dump file into
> schema2
>
> Is it just a
> matter of using REMAP_SCHEMA=schema1:schema2 ???
>
>
> Cheers
>
>
>
>
>
>

      Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/

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


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 27 2010 - 05:37:52 CST

Original text of this message