winnt to linux
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: winnt to linux

  1. #1
    Join Date
    Dec 2002
    Posts
    110

    winnt to linux

    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

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: winnt to linux

    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.

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    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 .

  4. #4
    Join Date
    Oct 2000
    Posts
    250
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width