Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    143

    Unanswered: oracle database migration

    We are migrating our oracle database version 9.2.0.6 from a unix(Sun OS) to unix(AIX). What would be the steps involved (on a high level) if I go with the export/import option ?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Export’s job is to create a platform-independent DMP file that contains all of the required metadata (in the form of CREATE and ALTER statements), and optionally the data itself to re-create tables, schemas, or even entire databases. Import’s sole job in life is to read these DMP files, and execute the DDL statements and load any data it finds.

    This is an excerpt from a Tom Kyte's article; read it here

Posting Permissions

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