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

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 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