Loading Oracle ctl export file into postgresql

Question

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.

• EdStevens: 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.
• Stevetech: I'm not trying to load then into oracle so sqldr doesn't help me.
• EdStevens: 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.
• Kassandry: @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.
• EdStevens: 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.

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