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?
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.