Slide 17
Slide 17 text
Types
Oracle generic types (date, number...) should be mapped to
Postgres more specific types date, time, timestamp, int, bigint,
numeric, double precision…
Oracle clobs should not be used - Postgres varlena types
have 1GB limit.
Oracle and Postgres are type strict databases. However
Oracle has some loose implicit conversions, on operations
over types date, number, varchar2, that are not type strict.
Oracle to PostgreSQL Migration