Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    76

    Unanswered: import and export of data

    Hello Everybody,

    I have Oracle running in two remote machines (different geographical locations). I need to import a schema from one Oracle installation to another installation. What is best possible solution:

    1) Generating the records of all the tables in the schema to a common file format CSV and then loading it in destination database. If this is ok then how to generate import and export data using CSV format
    2) Any other options?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Unless there are only a few tables with not so many data, CSV file wouldn't be a good choice at all. In my opinion, "ordinary" export and import is the simplest way. As you didn't mention Oracle database version you use, utility name might differ from export / import (EXP / IMP) to export / import data pump (EXPDP / IMPDP), but, in general, you'd use them the same way.

    To export a schema, you'd do something like this:

    OS> EXP username/its_password@database FILE=schema.dmp

    To import it, use

    OS> IMP username/its_password@database FILE=schema.dmp

    Read more about Oracle Data Pump 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
  •