0

I have a number of tables exported from an oracle database in the form of Ctl files with that data included within the file.

Im looking for a way to import these into postgresql but the the enterprise db toolkit seems to want a direct link to an already running oracle instance. A program similar to sql-loader would be excellent.

Improve this question
8
  • 1
    What do you mean "exported from an oracle database in the form of Ctl files with that data included within the file."? Exactly how were these files created? Most db products have a utility to import a simple csv file. That's what oracle's sqlldr does.
    – EdStevens
    Commented Jul 12, 2017 at 20:58
  • I'm not trying to load then into oracle so sqldr doesn't help me.
    – Stevetech
    Commented Jul 12, 2017 at 21:04
  • 1
    I know that you are not trying to load oracle. My point is that most products, and I'm guessing postgre is no different, have a utility like sqlldr to load simple csv files into their database. A simple csv file, not a "Ctl files with that data included within the file.", whatever that is.
    – EdStevens
    Commented Jul 12, 2017 at 21:09
  • 1
    @EdStevens is trying to get more information from you about how exactly you generated these "ctl" files. As far as know, a Control file isn't actually a database backup. Did you use something like Original Export/Import, Data Pump Import/Export, Full Transportable Import/Export or similar? Do you have a utility that will let you do a CSV export instead? Because that is a lowest common denominator and much easier for data import tools to use.
    – Kassandry
    Commented Jul 12, 2017 at 21:15
  • 1
    If you can't explain how they were created or what the actual format is then they could be anything in any format, and there is no way anyone could advise on how to use them. In the oracle world, a 'ctl' file in this context would mean a file used as parameter input (may or may not include data) for sqlldr. But that is not created by "exporting" anything (even a loose use of the term 'export') so it is still completely unclear what you have.
    – EdStevens
    Commented Jul 14, 2017 at 23:13

1 Answer 1

Reset to default
1

The solution is to load the data into oracle and then use one of the migration toolkits to move it to Postgres. Oracle produce a number of virtual box VMs that limit the effort needed but its still an extra step.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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