Re: Oracle Data Pump

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 11 Dec 2007 09:17:49 GMT
Message-ID: <475e55bc$0$1340$834e42db@reader.greatnowhere.com>

On Mon, 10 Dec 2007 10:13:03 -0800, haganahtrainer wrote:

> I want to import this schema and all objects into another instance and I
> have created the user "test" with connect and resource roles. I tried to
> import the dmp file into the new instance using both of the options
> below but keep getting an ORA 39112 Error - any suggestions??

Oracle does have some suggestions:

mg> oerr ora 39112
39112,00000, "Dependent object type %s skipped, base object type %s creation failed"
// *Cause: During a Data Pump import job, a dependent object is being skipped

//          because its base object creation failed.
// *Action: If the object from the dump file is wanted, drop the base and 
//          dependent objects and try to import again using desired 

filters
mg>

-- 
Mladen Gogala

Received on Tue Dec 11 2007 - 03:17:49 CST