Re: RE : Datapump question

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 27 Jan 2010 16:10:54 +0000
Message-ID: <7765c8971001270810k255880f0u71f35c78020ead47_at_mail.gmail.com>

hey thanks for that, I've always worked around it by rerunning the create type statement (same issue used to apply with exp/imp as well).

cheers

Niall

On Wed, Jan 27, 2010 at 11:37 AM, Bertrand Guillaumin < bertrand.guillaumin_at_digora.com> wrote:

> 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Wed Jan 27 2010 - 10:10:54 CST