expdp

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 »

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 Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.

by Ed Chen
December 23, 2020March 16, 2021

ORA-39195 ORA-39195 means that tables that you want to export does not exist in the current database, even though you qualify exported tables by schema… 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 »

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 IMP-00401 Error Message

by Ed Chen
April 23, 2017October 24, 2021

IMP-00401: dump file may be an Data Pump export dump file When I use original import utility to import data from a dump file, I… Read More »

How to Resolve ORA-39143 Error Message

by Ed Chen
April 23, 2017October 24, 2021

ORA-39143: dump file may be an original export dump file Was trying to import the data using impdp, but it threw an error ORA-39143. ORA-39143:… Read More »

How to Duplicate a Schema from One to Another

by Ed Chen
August 7, 2016May 14, 2021

Suppose you are planning to duplicate user01 schema into user02 schema. Tools like TOAD, SQL Developer can be helpful. But you may also like to… Read More »