Link to home
Start Free TrialLog in
Avatar of bibi92
bibi92Flag for France

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
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bibi92

ASKER

Thanks, I have no space on windows server.
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_file01.dbf',
    '/tmp/transport_win/my_ts_file02.dbf'
  FROM PLATFORM 'Windows (32-bit)'
  DB_FILE_NAME_CONVERT
    '/tmp/transport_win','/u01/oradata/MYDB';

Thanks
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
Avatar of bibi92

ASKER

the endianness are the same. So can I copy only the datafiles?

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?
Avatar of bibi92

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.
Avatar of bibi92

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.
Avatar of bibi92

ASKER

Thanks bibi