RE: Importing into Oracle 10g release 2 on Windows

RE: Importing into Oracle 10g release 2 on Windows

 

  

You could also try using expdp and impdp data pump utilities.

- Andrew

-----Original Message-----
From: Cliff Palmer
[mailto:oracledba-ezmlmshield-x57527889.[Email address protected]
Sent: Thursday, October 27, 2005 9:41 AM
To: LazyDBA Discussion
Subject: Re: Importing into Oracle 10g release 2 on Windows

Mark, there is a 10gR1 problem with export and import. Between 10.1.0.2
and 10.1.0.4, import and export were redesigned. We've had a lot of
trouble importing 10.1.0.2 exports into 10.1.0.4.
I'd recommend that you upgrade your 10gR1 to the latest 10gR1 release
before you try this.


On Thu, 2005-10-27 at 07:08 -0700, Rhoades Mark A SPL Contractor wrote:
> I just installed 10g release 2 on Windows.
>
> I exported a 10g release 1 schema and imported it to the new database.
> While importing I encountered primary key violations.
>
> My question is.... Is this some type of bug in release 2 since you can

> have data which does violate the primary key?
>
>
> Mark
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:

> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree

> to these terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html




_______________
Siebel
IT'S ALL ABOUT THE CUSTOMER
Visit www.siebel.com

This e-mail message is for the sole use of the intended recipient(s) and contains confidential and/or privileged information belonging to Siebel Systems, Inc. or its customers or partners. Any unauthorized review, use, copying, disclosure or distribution of this message is strictly prohibited. If you are not an intended recipient of this message, please contact the sender by reply e-mail and destroy all soft and hard copies of the message and any attachments. Thank you for your cooperation.


Oracle LazyDBA home page