FAQ
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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
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