RE : Datapump question
- From: Bertrand Guillaumin <bertrand.guillaumin@xxxxxxxxxx>
- To: "JDunn@xxxxxxxxx" <JDunn@xxxxxxxxx>, venkatramana reddy <reddymvr5@xxxxxxxxxxx>
- Date: Wed, 27 Jan 2010 12:37:52 +0100
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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] de la part
de John Dunn [JDunn@xxxxxxxxx]
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@xxxxxxxxxxx]
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@xxxxxxxxx> wrote:
> From: John Dunn <JDunn@xxxxxxxxx>
> Subject: Datapump question
> To: "oracle-l digest users" <oracle-l@xxxxxxxxxxxxx>
> 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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
