impdp

How to Resolve UDI-00014: invalid value for parameter

by Ed Chen
November 7, 2022October 17, 2022

UDI-00014 Saw error UDI-00014 when using impdp to import some tables. [oracle@test ~]$ impdp system/password@orclpdb tables=hr.employees remap_table=hr.employees,emp_bak dumpfile=expdp-full.dmp ... UDI-00014: invalid value for parameter, 'remap_table'… Read More »

How to Resolve UDI-28002: operation generated ORACLE error 28002

by Ed Chen
November 4, 2022November 6, 2022

UDI-28002 Saw error UDI-28002 when using expdp or impdp to migrate data. UDI-28002: operation generated ORACLE error 28002 ORA-28002: the password will expire within 7… Read More »

impdp REMAP_TABLE Multiple Examples

by Ed Chen
August 15, 2022October 29, 2022

REMAP_TABLE Single To prevent damaging the original tables, we usually import tables with different names for developers to verify. The parameter we should use in… Read More »

How to Resolve ORA-39071: Value for EXCLUDE is badly formed.

by Ed Chen
June 29, 2021July 14, 2022

ORA-39071 Saw some errors including ORA-39071 and ORA-39001 when export some tables form the database. [oracle@test ~]$ expdp system/password@orclpdb dumpfile=test.dmp logfile=test.log schemas=hr exclude=table:"in ('EMPLOYEES', 'DEPARTMENTS')"… Read More »

How to Resolve bash: syntax error near unexpected token `('

by Ed Chen
June 28, 2021July 16, 2022

bash: syntax error near unexpected token ( Tried to export some data by data pump, but it failed with bash: syntax error near unexpected token… Read More »

How to expdp PDB as SYSDBA without Password

by Ed Chen
December 23, 2020March 16, 2021
2 Comments

Expdp PDB as SYSDBA If we want to export data from a Pluggable Database (PDB) using expdp as sysdba by OS Authentication, we will get… Read More »

How to Resolve IMP-00038: Could not convert to environment character set's handle

by Ed Chen
September 2, 2020April 27, 2022

IMP-00038 I thought it was a character set conversion problem when using the original import (imp) to import a dump file, so I tried to… Read More »

impdp Parameter for All Releases of Oracle Database

by Ed Chen
August 5, 2020November 18, 2022

Here is the list of impdp available parameters for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. impdp… Read More »

expdp Parameter for All Releases of Oracle Database

by Ed Chen
August 1, 2020November 18, 2022

Here is the list of expdp available parameters for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. expdp… Read More »

How to Resolve ORA-01400: cannot insert NULL into

by Ed Chen
November 27, 2019October 17, 2021
2 Comments

ORA-01400 ORA-01400 means that there's a column which was found as NOT NULL is not listed in the INSERT statement, you have to provide a… Read More »