Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

te an insert per row returned, but with performances lost of courses. Best regards, -- Gilles Darold http://www.darold.net/

Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

Jagmohan Hi, Maybe what you are looking for is here https://github.com/MigOpsRepos/pg_dbms_errlog , this is a PostgreSQL extension that emulates the DBMS_ERRLOG Oracle package. Best regards, -- Gilles Darold http://www.darold.net/

Re: Transaction and SQL errors

ed so I don't think you might expect any planned work on this feature in any term. But who knows, things can evolve. [1] https://www.postgresql.org/message-id/983d80b3-d187-127a-2de5-38c92ccb38ab%40darold.net -- Gilles Darold http://www.darold.net/

Re: EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql

Le 20/08/2020 à 17:57, Ko, Christina a écrit : *From:* Gilles Darold *Sent:* Thursday, August 20, 2020 10:54 AM *To:* Ko, Christina (US) ; pgsql-general@lists.postgresql.org *Cc:* Ho, Chuong *Subject:* EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql Le 20/08/2020 à 16:30, Ko

Re: Loading Oracle Spatial Data to Postgresql

. Best regards, -- Gilles Darold http://www.darold.net/

Re: ora2pg error : DBD::Oracle::db prepare failed: ORA-28110

ecompile the package or the function after fixing the underlying problem." If you set COMPILE_SCHEMA to 1 in your ora2pg.conf, Ora2pg will first recompile the all functions but if the policy function is not in the schema you are exporting it will not help. Actually this is an Oracle issue you may want to contact an Oracle DBA to see what can be done. Best regards -- Gilles Darold http://www.darold.net/

Re: aws sct/dms versus ora2pg

Ora2Pg is a spare time project I guess that with the financial means of amazon their product is far better. If you or someone else give a try to both solution fill free to send feedback. Regards, -- Gilles Darold http://www.darold.net/

Re: Oracle to postgres migration via ora2pg (blob data)

tion to see what is the best value. On the other side you can use --ora2pg_speed option to see at which speed Ora2Pg is able to convert the data, nothing will be written too. Use it to know if you have some win with the value of the -j option. Don't forget to do some additional test with the BLOB_LIMIT value to see if there some more improvement. If someone can prove me that they have better performances at Oracle data extraction side I will be pleased to look at this code. I hope this will help.   Regards, -- Gilles Darold http://www.darold.net/