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
Printable View
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
check the certification matrix for the version of linux & database atQuote:
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.
http://otn.oracle.com/support/metalink/content.html
Sure, the user data can be imported like this.Quote:
can i use export copies of oracle on linux & import them into winnt
HTH.
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 .
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.