Gilles Darold
Gilles Darold
Thanks for the report, there is lot of formatting problems with CTE, see #202, #192 and #195. I need to rethink and rewrite lot of code to fix CTE. This...
This is probably because Ora2Pg only export users that have privileges on the database objects. I will have a look.
Not yet, I will try to allow that in Ora2Pg in the week.
Not for the moment, actually this is not a high priority and as you can see there is lot of issues asking for enhancement.
How about if you keep all in UTF8 by keeping the default for NLS_LANG , NLS_NCHAR and CLIENT_ENCODING in ora2pg.conf? You just have to comment out the lines.
Probably the foreign key doesn't exists on Oracle side, Ora2Pg takes the FK definition from oracle, not PG. You might want to restore the database with section pre-data only, import...
Not reproducible, closing.
Can you post the output of the following command: ``` ora2pg -p -m -t PARTITION -o partition.sql -b ./schema/partitions -c ./config/ora2pg.conf -v ``` Also what is your setting of PG_VERSION...
Actually the work on exporting partitions for MySQL was never ended, it don't works at all with latest change in partitioning export. I will fix that.
Commit eb5eb2b might fix MySQL partition export. I still have to work on sub partition but if you don't have such object you can test latest development code.