How to move database from nt to unix
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to move database from nt to unix

  1. #1
    Join Date
    Aug 2001
    Posts
    267
    We are planning to move the database from nt to unix .. Will the export /import option works . Can be transport tablespaces from nt to unix on ver 9i ...Looking for Guru's help to find best method to do this job ..
    Raghu

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Export/import is the best method to move your data.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2001
    Posts
    290

    Question

    what if your database is so big and wanted to do export & import, think its time consuming , is there any other way of doing the things much better in 8i/9i

    Thanks,
    Madhu

  4. #4
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    You cannot use transportable tablespaces across different OS's.

    If you have a large database, there is no quick way to migrate.

    I suggest your best bet is a definition export from the NT db (FULL=Y, ROWS=N). Set up the tablespaces on the Unix server, then do an import of the definition. This will define all the tables and users. At this point you can run several parallel scripts to copy the data from the NT server to the Unix server.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  5. #5
    Join Date
    Aug 2001
    Posts
    267
    Before 9i release somebody told me Oracle is providing transportable tablespaces across OS . I just want to confirm this ..If there is one I am one of the happiest person's ...
    Raghu

  6. #6
    Join Date
    Feb 2001
    Posts
    290

    Unhappy

    I suggest your best bet is a definition export from the NT db (FULL=Y, ROWS=N). Set up the tablespaces on the Unix server, then do an import of the definition. This will define all the tables and users. At this point you can run several parallel scripts to copy the data from the NT server to the Unix server.
    __________________

    I really didnt get you , may be i couldnt understand the parallel copy scripts , do you have any ???

    I would like to know more about this ...

    Thanks in advance
    Madhu


  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I think he's taking about either using the SQLPlus COPY command or doing multiple imports at once.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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