impdp

How to Resolve UDI-00014: invalid value for parameter

by Ed Chen
November 7, 2022March 20, 2023

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_TABLESPACE Multiple Examples

by Ed Chen
August 15, 2022January 25, 2023

In this post, we'll talk about 2 topics. REMAP_TABLESPACE Single Tablespace REMAP_TABLESPACE Multiple Tablespaces REMAP_TABLESPACE Single Tablespace To prevent ORA-00959: tablespace does not exist when… Read More »

impdp REMAP_TABLE Multiple Examples

by Ed Chen
August 15, 2022January 25, 2023

In this post, we'll talk about 2 topics. REMAP_TABLE Single Table REMAP_TABLE Multiple Tables REMAP_TABLE Single Table To prevent damaging the original tables, we usually… Read More »

How to Resolve ORA-00959: tablespace does not exist

by Ed Chen
May 25, 2022March 20, 2023

ORA-00959 ORA-00959 means that the tablespace you specified in the statement cannot be found in the database, you should check the name you provide or… 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
4 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, 2020December 9, 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, 2020March 20, 2023

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 »