Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.