Home > Documentation >
Oracle to PostgreSQL > Tutorial
Step 5 of 7. Conversion Settings
On this wizard screen you can customize the conversion process using
the following settings:
- Convert table definitions only - select this checkbox to
convert only table definitions of Oracle data. All the data will not
- Make names case sensitive - select this checkbox to make table
and column names case sensitive. In this mode all table and column names
are enclosed in double quotes to preserve upper/lower case. If you don't
want to use double quotes around names in queries, keep this option
- Skip converting indexes - select this checkbox if you don't
want to convert indexes
- NUMBER w/o precision -> bigint - select this checkbox to
convert all columns having type NUMBER without precision into BIGINT
(by default it is converted into DOUBLE PRECISION based on the range of
You can handle schema in the destination database according one of the
- Use existing: specify existing schema to import all tables there.
- Create new: create new schema to import all tables there.
- Full replication - import full list of schemas from the original database.
Use this mode to preserve full names of all tables the same as in the original database.