Oracle 8i - Migration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle 8i - Migration

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

    I want to migrate my Oracle 8i database on Solaris 5.7 to another server - with same configuration.
    My database is a very small one, with just about 30 tables and 5 procedures.
    Do you think just transferring the tables with any 3rd party tool like SQL DTS would do? or do I need to dump my database script and follow the traditional method??
    If yes, what are the steps I need to follow?? What are the precautions I need to take??

    Thanks for any help.
    Shiva.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. install oracle software on new_server
    2. make mount points the same on new_server look the same as old_server
    3. shutdown database on old_server
    4. copy files to same location on new_server
    5. startup database on new server
    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
    Jan 2001
    Posts
    71
    use export and import is easier. choose the owner of the tables and procedures and export. import this exported file to new database. you even can export from unix and import to NT based oracle or different version oracle.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if the database is small as you said use exp/imp if large then marist's suggestion would be faster

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