Gilles Darold

Results 346 comments of Gilles Darold

Use `-t SEQUENCE_VALUES` to export the alter statements to set the latest value of each sequences

It is available since version 24.0: ``` commit b711cc638f945e320237cf2457136021f08186a2 Author: Gilles Darold Date: Thu Mar 16 22:51:31 2023 +0100 Add SEQUENCE_VALUES export type to export DDL to set the last...

What is your ora2pg command and the result of the following command? ``` grep -E "^(JOB|PARALLEL_TAB|ORACLE_COPIES|DATA_LIMIT|BLOB_LIMIT)" config/ora2pg.conf ```

>1. Does it mean the schema that was assessed has 5 stored procedures and the total estimated cost to refactor and migrate these 5 stored procedures would be 100 estimated...

Right, an automatic conversion, even imported successfully in PostgreSQL, doesn't means that there is no issues with non-existing objects or that ir returns different results for example. Only execution of...

> This 500 mins is the time expected for import, review ora2pg converted code if any, manual conversion if any and testing? Yes this is what it means but the...

I don't know the reason of this error. Please use a Linux box, things will be easier.

No, a command is missing. ddltool

Hi @dschaell you should use the following for this big table: ``` WHERE TABLE1[Time_Created >= ADD_MONTHS(SYSDATE, -8)] ``` then you can use `-P` to parallelize all table export. If only...

Commit 8ec00f1 fix parsing of the %r placeholder.