Remember ORA-39405 with impdp? There is a fix for it
Remember my blog post about time zone problems during import from one year ago? When you try to import into an Oracle database and your source database you exported from had a higher time zone (DST) patch level than the target, the impdp failed…
Remember my blog post about time zone problems during import from one year ago? When you try to import into an Oracle database and your source database you exported from had a higher time zone (DST) patch level than the target, the impdp failed…
Remember ORA-39405 with impdp? There is a fix for it
Remember my blog post about time zone problems during import from one year ago? When you try to import into an Oracle database and your source database you exported from had a higher time zone (DST) patch level than the target, the impdp failed with ORA-39405 and stopped. In this blog post I showed several workarounds including some insane ones. And I've been contacted by customers and colleagues quite a few times asking for a general remedy.
mikedietrichde.com
February 5, 2025 at 4:10 PM
Remember ORA-39405 with impdp? There is a fix for it
Remember my blog post about time zone problems during import from one year ago? When you try to import into an Oracle database and your source database you exported from had a higher time zone (DST) patch level than the target, the impdp failed…
Remember my blog post about time zone problems during import from one year ago? When you try to import into an Oracle database and your source database you exported from had a higher time zone (DST) patch level than the target, the impdp failed…
#Oracle #IMPDP erhält durch die Data Pump Bundle Patches interessante neue Funktionalitäten. Welche das sind findet Ihr in meinem Blog
@oracleace.bsky.social @mikedietrichde.com @doagev.bsky.social
www.database-blog.at/2026/04/03/n...
@oracleace.bsky.social @mikedietrichde.com @doagev.bsky.social
www.database-blog.at/2026/04/03/n...
Neue Data Pump Funktionen in Data Pump Bundle Patches – Database Blog
www.database-blog.at
April 3, 2026 at 8:33 AM
#Oracle #IMPDP erhält durch die Data Pump Bundle Patches interessante neue Funktionalitäten. Welche das sind findet Ihr in meinem Blog
@oracleace.bsky.social @mikedietrichde.com @doagev.bsky.social
www.database-blog.at/2026/04/03/n...
@oracleace.bsky.social @mikedietrichde.com @doagev.bsky.social
www.database-blog.at/2026/04/03/n...
本番化前＆開発環境で起きて良かった
DataPump Import (IMPDP) Of Triggers Fails With Errors ORA-39126 ORA-6502 LPX-225 ORA-6512
https://support.oracle.com/knowledge/Oracle%20Database%20Products/970962_1.html
DataPump Import (IMPDP) Of Triggers Fails With Errors ORA-39126 ORA-6502 LPX-225 ORA-6512
https://support.oracle.com/knowledge/Oracle%20Database%20Products/970962_1.html
DataPump Import (IMPDP) Of Triggers Fails With Errors ORA-39126 ORA-6502 LPX-225 ORA-6512
Oracle Database - Enterprise Edition - Version 11.1.0.7 and later: DataPump Import (IMPDP) Of Triggers Fails With Errors ORA-39126 ORA-6502 LPX-225 ORA-6512
support.oracle.com
February 4, 2025 at 10:45 AM
本番化前＆開発環境で起きて良かった
DataPump Import (IMPDP) Of Triggers Fails With Errors ORA-39126 ORA-6502 LPX-225 ORA-6512
https://support.oracle.com/knowledge/Oracle%20Database%20Products/970962_1.html
DataPump Import (IMPDP) Of Triggers Fails With Errors ORA-39126 ORA-6502 LPX-225 ORA-6512
https://support.oracle.com/knowledge/Oracle%20Database%20Products/970962_1.html
Another approach is: I took a dumpfile containing hr,sh,oe,pm,bi,ix schemas whenever needed just impdp.
November 17, 2024 at 8:52 PM
Another approach is: I took a dumpfile containing hr,sh,oe,pm,bi,ix schemas whenever needed just impdp.
Christian Pfundtner (@CPfundtner) beschreibt in seiner DOAG Datenbank Kolumne die typischen Probleme und deren Lösungen, die sich beim Export und Import von Daten per EXPDP/IMPDP ergeben können. https://scomp.ly/KVVNx56
November 27, 2024 at 4:35 PM
Christian Pfundtner (@CPfundtner) beschreibt in seiner DOAG Datenbank Kolumne die typischen Probleme und deren Lösungen, die sich beim Export und Import von Daten per EXPDP/IMPDP ergeben können. https://scomp.ly/KVVNx56
ORA-39405 Error TSTZ al hacer expdp/impdp. Otra forma de importar los datos dbaspain.com/2025/03/13/o...
He podido importar los datos que necesitaba en una versión anterior de timezone.
¿Quieres que te cuente el secreto? Acompáñame ⤵️
He podido importar los datos que necesitaba en una versión anterior de timezone.
¿Quieres que te cuente el secreto? Acompáñame ⤵️
ORA-39405 Error TSTZ al hacer expdp/impdp. Otra forma de importar los datos » 💻 DBASpain | Por Cele Cueva
Estoy completamente seguro que el 90% de los DBAs existentes en el planeta tierra se han encontrado con este error alguna vez. Al igual que yo, te has puesto a buscar alternativas, soluciones, parches...
dbaspain.com
March 13, 2025 at 5:41 PM
ORA-39405 Error TSTZ al hacer expdp/impdp. Otra forma de importar los datos dbaspain.com/2025/03/13/o...
He podido importar los datos que necesitaba en una versión anterior de timezone.
¿Quieres que te cuente el secreto? Acompáñame ⤵️
He podido importar los datos que necesitaba en una versión anterior de timezone.
¿Quieres que te cuente el secreto? Acompáñame ⤵️
impdp - which rows failed? http://www.db-oriented.com/2014/07/19/impdp-which-rows-failed/ #oracle
impdp - which rows failed? - @DBoriented
Since version 11.1, Data Pump Import supports the SKIP_CO...
www.db-oriented.com
November 23, 2024 at 3:32 AM
impdp - which rows failed? http://www.db-oriented.com/2014/07/19/impdp-which-rows-failed/ #oracle
Can you tell WHICH rows not loaded by #oracle Data Pump Import due to constraint violation?
Some #trickery helps ;)
http://www.db-oriented.com/2014/07/19/impdp-which-rows-failed/
Some #trickery helps ;)
http://www.db-oriented.com/2014/07/19/impdp-which-rows-failed/
impdp - which rows failed? - @DBoriented
Since version 11.1, Data Pump Import supports the SKIP_CO...
www.db-oriented.com
November 23, 2024 at 1:22 AM
Can you tell WHICH rows not loaded by #oracle Data Pump Import due to constraint violation?
Some #trickery helps ;)
http://www.db-oriented.com/2014/07/19/impdp-which-rows-failed/
Some #trickery helps ;)
http://www.db-oriented.com/2014/07/19/impdp-which-rows-failed/
Can you tell WHICH rows not loaded by #oracle Data Pump Import due to constraint violation?
Some #trickery helps ;)
http://db-oriented.com/2014/07/19/impdp-which-rows-failed/
Some #trickery helps ;)
http://db-oriented.com/2014/07/19/impdp-which-rows-failed/
impdp - which rows failed? - @DBoriented
Since version 11.1, Data Pump Import supports the SKIP_CO...
db-oriented.com
November 22, 2024 at 11:05 PM
Can you tell WHICH rows not loaded by #oracle Data Pump Import due to constraint violation?
Some #trickery helps ;)
http://db-oriented.com/2014/07/19/impdp-which-rows-failed/
Some #trickery helps ;)
http://db-oriented.com/2014/07/19/impdp-which-rows-failed/
#orcldb Data Pump Import with SKIP_CONSTRAINT_ERRORS uses DML Error Logging under the hood.
But how to find which records were skipped exactly? Here is a trick that includes blocking the impdp session (twice).
http://db-oriented.com/2014/07/19/impdp-which-rows-failed/
#fromthearchive
But how to find which records were skipped exactly? Here is a trick that includes blocking the impdp session (twice).
http://db-oriented.com/2014/07/19/impdp-which-rows-failed/
#fromthearchive
impdp - which rows failed? - @DBoriented
Since version 11.1, Data Pump Import supports the SKIP_CO...
db-oriented.com
November 22, 2024 at 6:56 PM
#orcldb Data Pump Import with SKIP_CONSTRAINT_ERRORS uses DML Error Logging under the hood.
But how to find which records were skipped exactly? Here is a trick that includes blocking the impdp session (twice).
http://db-oriented.com/2014/07/19/impdp-which-rows-failed/
#fromthearchive
But how to find which records were skipped exactly? Here is a trick that includes blocking the impdp session (twice).
http://db-oriented.com/2014/07/19/impdp-which-rows-failed/
#fromthearchive
Just answered-impdp commit size parameter https://asktom.oracle.com/pls/asktom/asktom.search?tag=impdp-commit-size-parameter
November 5, 2025 at 3:10 PM
Just answered-impdp commit size parameter https://asktom.oracle.com/pls/asktom/asktom.search?tag=impdp-commit-size-parameter
#AskTOM Just answered: Impdp import error, ORA-39001 http://bit.ly/2vgYEJ7
December 4, 2024 at 11:51 AM
#AskTOM Just answered: Impdp import error, ORA-39001 http://bit.ly/2vgYEJ7
#AskTOM, from the #database: impdp is failing with below errors with full database import. http://bit.ly/2gsKgUx
December 4, 2024 at 9:26 AM
#AskTOM, from the #database: impdp is failing with below errors with full database import. http://bit.ly/2gsKgUx
#AskTOM Just answered: impdp with multiple REMAP_SCHEMA statements tries to load data twice in the same schema http://bit.ly/2EvUmQe
December 3, 2024 at 10:54 PM
#AskTOM Just answered: impdp with multiple REMAP_SCHEMA statements tries to load data twice in the same schema http://bit.ly/2EvUmQe
#AskTOM Just answered: Unable to get expdp/impdp utility run successfully, getting ORA-39002: invalid operation ORA-3907... http://bit.ly/2GM5ahy
December 3, 2024 at 7:11 PM
#AskTOM Just answered: Unable to get expdp/impdp utility run successfully, getting ORA-39002: invalid operation ORA-3907... http://bit.ly/2GM5ahy
#AskTOM impdp is failing with below errors with full database import. http://bit.ly/2gsKgUx
December 3, 2024 at 6:12 PM
#AskTOM impdp is failing with below errors with full database import. http://bit.ly/2gsKgUx
#AskTOM Just answered: More archives during impdp, what is the exact reason and what will happen internally http://bit.ly/2IGdfSi
December 3, 2024 at 8:19 AM
#AskTOM Just answered: More archives during impdp, what is the exact reason and what will happen internally http://bit.ly/2IGdfSi
#AskTOM Just answered: REMAP_TABLESPACE not working during impdp http://bit.ly/2LTJFKK
December 3, 2024 at 4:10 AM
#AskTOM Just answered: REMAP_TABLESPACE not working during impdp http://bit.ly/2LTJFKK
#AskTOM Just answered: Impdp fails with errors on TEMP and UNDO http://bit.ly/2M1VXkr
December 3, 2024 at 3:48 AM
#AskTOM Just answered: Impdp fails with errors on TEMP and UNDO http://bit.ly/2M1VXkr
Popular on #AskTOM what is the difference between shrink ,move and impdp http://bit.ly/2TMveuj
December 3, 2024 at 12:48 AM
Popular on #AskTOM what is the difference between shrink ,move and impdp http://bit.ly/2TMveuj
Previously on #AskTOM what is the difference between shrink ,move and impdp https://asktom.oracle.com/pls/apex/asktom.search?tag=what-is-the-difference-between-shrink-move-and-impdp
December 2, 2024 at 10:52 AM
Previously on #AskTOM what is the difference between shrink ,move and impdp https://asktom.oracle.com/pls/apex/asktom.search?tag=what-is-the-difference-between-shrink-move-and-impdp
Previously on #AskTOM Impdp import error, ORA-39001 https://asktom.oracle.com/pls/apex/asktom.search?tag=impdp-import-error-ora-39001
December 2, 2024 at 7:35 AM
Previously on #AskTOM Impdp import error, ORA-39001 https://asktom.oracle.com/pls/apex/asktom.search?tag=impdp-import-error-ora-39001