I will venture to guess you could do this if you upgraded both databases
to 10gR2 and use transportable tablespaces. Then with some added
instructions you could copy the files and 'import' the metadata so the
destination will make them part of the database. I believe this uses a
combination of RMAN and transportable tablespaces.
A straight copy will not work between OS's.
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: Holder Mark
[mailto:oracledba-ezmlmshield-x35205470.[Email address protected]
Sent: Thursday, November 02, 2006 11:32 AM
To: LazyDBA Discussion
Subject: Move data files between OS versions
I have 2 environments; both Windows Server 2003 running 9i (prod and
test) - all 32 bit.
Because of issue exporting extremely large table I move the physical
data/control/redo files to replicate prod to test. This works like a
champ - move files, perform alter and I'm up and running.
Now, I've be given a Windows XP Pro x64 version machine and have copies
of oracle 9i and 10g-win64.
Questions;
1. can I move files as before to this new x64bit machine with 9i? (I've
started this process today...takes about 4 hours to move files due to
total size > 200GB - but, will it work when I get to that point.)
2. is there an incompatibility issue between oracle files in 32bit vs.
64bit environment within same release of oracle (9i)?
3. can I perform the move between 32bit 9i and 64bit 10g and have same
success as above?
Thanks in advance for any feedback / experience.
- Mark
DISCLAIMER:
This e-mail is for the intended recipient only.
If you have received it by mistake please let us know by reply and then
delete it from your system; access, disclosure, copying, distribution or
reliance on any of it by anyone else is prohibited.
If you as intended recipient have received this e-mail incorrectly,
please notify the sender (via e-mail) immediately.
---------------------------------------------------------------------
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
Oracle LazyDBA home page