On Wed, 14 Mar 2001, Mary Christie Generalao wrote:
..
> Btw, is it ok to move oracle's data tree when
> migrating from one server to another? Im just curious.
> Our current production oracle8.6.1 is in solaris with
> data in /u02. Suppose I wanted to create an oracle 
> development server on a linux machine, same version as
> that in solaris and wanted to have existing data in
> solaris as my startup data in linux- is it safe to
> just copy entire /u02 of solaris into linux's oracle

No it is not safe. If the underlying filesystem block size is different,
you are SCREWED!! plus, SPARC is big-endian while Intel IA32 is
little-endian: more opportunities for screwing.

In fact, I once tried to transfer Oracle files from an ext2 to a ReiserFS
partition on the SAME Linux box: no dice.

You need to EXP your entire database (or subset thereof) on SPARC then IMP
it on the Linux box.


---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]>       POTS Phone: +63   (2) 848-2893
Mosaic Communications, Inc.            GSM Mobile: +63 (917) 531-5893
I'm not suffering from insanity -- I'm enjoying  every minute of it!!

_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]

To subscribe to the Linux Newbies' List: send "subscribe" in the body to 
[EMAIL PROTECTED]

Reply via email to