Importing into Unix from NT environment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Importing into Unix from NT environment

  1. #1
    Join Date
    Jan 2002
    Posts
    58

    Importing into Unix from NT environment

    Okay we are migrating an Oracle database from an NT platform to a Sun Solaris platform. I want to be able to recreate the tablespaces the way they are, other than the mount points being different. Is there anything special in the import process that I need to do to ensure that the tablespaces are created properly on the Unix system. thanks

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    You will have to create the tablespaces yourself before the import.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2002
    Posts
    58
    oh okay, and then name them what they are on the NT system. What about the different mount point aka... D:\oradata to /dis3/oradata/???

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by antilles
    oh okay, and then name them what they are on the NT system. What about the different mount point aka... D:\oradata to /dis3/oradata/???
    The tablespace name in the destination db on Solaris should be the same as that of the source on NT. The name/format of the datafile does not matter. That is the whole purpose of export/import (cross platform compatability)!

    HTH.

  5. #5
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    1. Create the tablespaces on Solaris with the same tablespace names as they were on Windows.

    However, you have a chance to size them properly and/or place them on different mount points for performance. Take advantage of the migration and organize your physical structures accordingly for maximum performance in your new environment.
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

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