winnt to linux

[zulu99]

Hi


we are planning to shift our oracel8.1.6 database from winnt to red dhat linux 8.0 . what things i need to take care before going ahead.
can i use export copies of oracle on linux & import them into winnt



Thanx

[ggnanaraj]

Originally posted by zulu99
Hi
we are planning to shift our oracel8.1.6 database from winnt to red dhat linux 8.0 . what things i need to take care before going ahead.

check the certification matrix for the version of linux & database at
http://otn.oracle.com/support/metalink/content.html

can i use export copies of oracle on linux & import them into winnt

Sure, the user data can be imported like this.

HTH.

[prakashs43]

I think u should create dblink and then use exp and imp commands from LINUX . while giving the user name use username@dblink .
u can use snap shot method as well .

[ckwan]

Hi zulu99,
1. Is better to set database configuration same as source like DB_BLOCK_SIZE, DB_BLOCK_BUFFER, SORT_AREA_SIZE ,etc.
2. Make sure the tablespace created in the destination must equal or greater than the source.
3. Create same owner as in the source and set default tablespace
4. export from source and import to the destination.


Hopes this will help.