RE: Datapump question
- From: "John Dunn" <JDunn@xxxxxxxxx>
- To: "venkatramana reddy" <reddymvr5@xxxxxxxxxxx>
- Date: Wed, 27 Jan 2010 11:28:50 -0000
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
Other related posts:
