FAQ
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
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=: directory= dumpfile= logfile=

Regards
Ramana
--- On Wed, 27/1/10, John Dunn wrote:
From: John Dunn
Subject: Datapump question
To: "oracle-l digest users"
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/

Search Discussions

  • Niall Litchfield at Jan 27, 2010 at 4:10 pm
    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
    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=: directory=
    dumpfile= logfile=

    Regards
    Ramana
    --- On Wed, 27/1/10, John Dunn wrote:
    From: John Dunn
    Subject: Datapump question
    To: "oracle-l digest users"
    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 27, '10 at 11:37a
activeJan 27, '10 at 4:10p
posts2
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase