NOTE: In short, the database that was in postgres was migrated to oracle, but a table that is not automatically migrated by the system was missing.
I want to know what is the best way to do this if you can do it manually or use some tool between postgres and oracle?
I found a way to export a table from the PostgreSQL database to the format .csv and then after the .csv file is created, just import it into the database. Oracle .
Command to generate file .csv of a PostgreSQL table : (Perform command by pgAdmin)
copy (select * from database table ) to 'Path where the .csv file will be saved' with csv header
As I do not have an Oracle database installed I leave a link to the video that shows how to import the .csv file into Oracle
Hello, I use a "PL / SQL Developer" tool. When it is for small jobs, as a single table, we export to an Excel and import by PLSQL Developer as follows: select * from your table for update - then open (by clicking a padlock) and paste the excel data that is in the same pattern as the table. I do not know if this can help, but this tool helps me a lot.
