Hi,
use transportable tablespaces feature need to be on same OS; in this case
it will not work.
"You could export all your objects, code etc but not the rows and then
insert
using selects' ; this way will work and you need dblink to do the select
as insert
and insert is very quick.

Sue




"Hornung Bruce W \(US SSA\) "
<oracledba-ezmlmshield-x27773531.[Email address protected]
09/29/2007 06:56 AM


To
"LazyDBA Discussion" <[Email address protected]

cc


Subject
RE: 500 GIG database refresh?







use transportable tablespaces feature and rman to change endian

________________________________

From: Michael Peel [mailto:oracledba-ezmlmshield-x46523255.[Email address
protected]
Sent: Sat 9/29/2007 4:45 AM
To: LazyDBA Discussion
Subject: RE: 500 GIG database refresh?



You could export all your objects, code etc but not the rows and then
insert
using selects.

An alternative would be sql copy.

M

-----Original Message-----
From: will landstrom
[mailto:oracledba-ezmlmshield-x59213598.[Email address protected]
Sent: 28 September 2007 21:49
To: LazyDBA Discussion
Subject: 500 GIG database refresh?



Hello DBAS. I need to take a 500 GIG 10.2.2 database from server A and
copy
it to server B. 2 ways I am considering (neither are very good)
A) just take a bib export file and import the whole thing (will take a
long
long time to run)
B) use a hotback of the database and recover (very quick but not plausible
because server B has a file system (AIX) not compatible with server A
(Solaris).

By any chance does anyone have any other suggestions how to do this
efficiently?

Thanks, Will




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




To: "LazyDBA Discussion" <[Email address protected]
cc:
From: "Hornung Bruce W \(US SSA\) "
<oracledba-ezmlmshield-x27773531.[Email address protected]

**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************

Oracle LazyDBA home page