Linux Operating System (MOSC)

MOSC Banner

Migration using datafile convert solaris to linux.

edited Nov 18, 2013 11:18AM in Linux Operating System (MOSC) 1 commentAnswered
Hi,

I am migrating a very large tablespace from 10.2.0.2.0(Solaris[tm] OE (64-bit) Big endian )  to 11.2.0.3.0 (Linux x86 64-bit - little endian) using datafile convert.

On the source(Solaris platform) I switch to read only mode and do the usual exportdp. I also run ther following to extract the datafiles.

onvert datafile '/xxx/xxx/xxx.dbf','/yyy/yyy/yy.dbf'
to platform 'Solaris[tm] OE (64-bit)'
format '/tmpy/%N%f.dbf' ;

The files created are then copied to the Linux server. I then convert to Linux and to ASM using -

CONVERT DATAFILE
'/tempy/12345.dbf', 
'/tempy/67890.dbf'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center