sharath, January 21, 2009 - 4:24 pm UTC
Thank you. That was an excellent suggestion.
Contents of v$db_transportable_platform
Russ Cannon, January 23, 2009 - 10:59 am UTC
The v$db_transportable_platform view appears only to include platforms that are implicitly compatible with the present one. Is there some reason for this, and is there any way to expand the list to test for other platforms?
January 23, 2009 - 1:04 pm UTC
it has to do with byte ordering and word size - yes, and there is no way to expand the list.
For all other platform to platform conversions - we can do everything pretty much except for SYSTEM, rman does that be processing and reformatting the files.
what if its cross-platform with different endian format
sharath, May 05, 2009 - 2:50 pm UTC
Hi Tom, what if i need to migrate cross-platform with different endian format and need to retain oracle database usersids.
For example source A(aix 64 bit) to source b(linux 32 bit).
May 11, 2009 - 8:54 am UTC
you'd need to use exp/imp (or more preferably the data pump in 10g and above) to migrate the user accounts.
what if its cross-platform with different endian format
Sharath, May 11, 2009 - 10:16 am UTC
But that will not retain my databse userid.
May 11, 2009 - 6:47 pm UTC
I thought you mean your usernames/passwords.
There is no way to "preserve" the user_id assigned and visible in ALL_USERS, that is just our internal surrogate key (reason 1523523 to not use surrogates :( )