- I would like to make a connection to an oracle database.
- Then I want to make a connection to a postgres database.
3)Then a new table should be created in the postgres database. (it also has geometric attributes that are particularly difficult to handle with API s from oracle to postgres) This table must has a primary key and all Attributes (right datatypes) from the oracle database - Then the new database created in postgres should be filled with the data from the oracle database.
- Finally, the connections are closed when everything has worked
The code should be in python with usind oracledb library.
The most difficult thing was to handle the geometries.
New contributor
user26879298 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.