Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to export data from an Oracle database and then import the data to another oracle database. To import data, I can use SQLLDR tool to load a flat text file. To do that, I have to generate this flat text file from a Oracle database table first.

Are there any examples to use this tool? I need to pass Oracle database name, schema name with user/pwd, table name, constrains, and date time column format information to generate a text file. This text file will be used by SQLLDR tool.

share|improve this question
up vote 1 down vote accepted

You'd be better off using EXP/IMP or EXPDP/IMPDP if transferring from one Oracle database to another. They are covered in the Utilities manual

If you MUST use a CSV file, the unloader tool on the AskTom site. But be careful to check dates/timestamps and any exotic datatypes.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.