RE : Datapump question
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-lReceived on Wed Jan 27 2010 - 05:37:52 CST