RE: Cross-platform database move

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Tue, 16 Aug 2005 16:29:47 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E0465D2AD@ecogenemld50.Org.Collegeboard.local>

I have completed several medium and large "Cross Platform Oracle migrations"
[using EXP/IMP for most of it...and some other creative movement methods}

Unfortunately the devil is in the details.

Potential pains;

24X7 db / app
grants by sys
use of advanced datatype (XML, TIMESTAMP, LOB cause problems/slowness)
enabling constraints
snapshots and or replication issues
invalid objects
and any number of potential bugs (just had one where Oracle failed to create private synonyms for objects over db links)

Any when you realize this it is better to break up the EXP/IMP for speed the will only further require a detailed plan or something is bound to be left behind or undone.

hth

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fred Smith Sent: Tuesday, August 16, 2005 12:53 PM
To: oracle-l_at_freelists.org
Subject: Cross-platform database move

Hello,
I am attempting to make a copy of a production database that is on HP-UX and put it on a Solaris 5.8 box for testing. What are my choices for copying from one platform to the other? Just exp/imp? Both databases are 9.2.0.x. I'm dealing with roughly 90Gig.

tia,
-Fred S.

Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 16 2005 - 15:32:14 CDT