bibi92
asked on
convert datafile windows 32 bits on linux 64 bits
Hello
I have to convert datafile windows 32 bits on linux 64 bits on destination host.
How can I do?
Thanks
bibi
I have to convert datafile windows 32 bits on linux 64 bits on destination host.
How can I do?
Thanks
bibi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Never tried this but the doc link I provided seems to imply you can.
From the docs in step 4:
If you have transported the tablespace set to a platform with different endianness from the source platform, and you have not performed a source-side conversion to the endianness of the target platform, you should perform a target-side conversion now.
From the docs in step 4:
If you have transported the tablespace set to a platform with different endianness from the source platform, and you have not performed a source-side conversion to the endianness of the target platform, you should perform a target-side conversion now.
ASKER
the endianness are the same. So can I copy only the datafiles?
Thanks
bibi
Thanks
bibi
I've never done it. Not sure. I have to go by what the docs say.
Do you not have a test system where you can try it and see?
Do you not have a test system where you can try it and see?
ASKER
Yes, but the db size is 600go
OK then, do you have a development system?
Just a small database you can experiment with? This is the only way to know for sure it will work.
Just a small database you can experiment with? This is the only way to know for sure it will work.
ASKER
no sorry
You will have to 'test' it sooner or later. Nothing posted on a site like this should be taken as 100% accurate 100% of the time. What works for one shop, might not work for another.
The docs seem to say it is possible. Not sure what else to tell you.
Maybe another Expert will be along that has actually done this in an environment that matches yours. Even then, if they say, sure you can do it. Then what? It still might fail for you.
You must have the ability to test things before you try them in production.
The docs seem to say it is possible. Not sure what else to tell you.
Maybe another Expert will be along that has actually done this in an environment that matches yours. Even then, if they say, sure you can do it. Then what? It still might fail for you.
You must have the ability to test things before you try them in production.
ASKER
Thanks bibi
ASKER
Can I stop the db on windows and copy the datafile on linux and then :
# Conversion on a Linux destination host from a Solaris source file.
CONVERT DATAFILE=
'/tmp/transport_win/my_ts_
'/tmp/transport_win/my_ts_
FROM PLATFORM 'Windows (32-bit)'
DB_FILE_NAME_CONVERT
'/tmp/transport_win','/u01
Thanks