impdp

How to Resolve ORA-31619: invalid dump file

by Ed Chen
July 31, 2023August 1, 2023

ORA-31619 Saw error ORA-31619, when we tried to import data from a dump file. [oracle@test ~]$ impdp system/password@orcl full=yes directory=BACKUP2 dumpfile=full.dmp logfile=full.log ... ORA-39001: invalid… Read More »

How to Resolve ORA-31640: unable to open dump file

by Ed Chen
July 25, 2023July 26, 2023

ORA-31640 Tried to import data into the database from a dump file, but it failed with ORA-31640. Linux [oracle@test ~]$ impdp system/password@orcl full=yes directory=BACKUP2 dumpfile=full.dmp… Read More »

How to Resolve ORA-02304: invalid object identifier literal

by Ed Chen
June 2, 2023May 2, 2023

ORA-02304 When we copy all data from one schema to another through a loopback database link, we saw ORA-02304. [oracle@test ~]$ impdp system@orclpdb schemas=ERP remap_schema=ERP:ERP2… Read More »

How to Resolve ORA-39165: Schema was not found

by Ed Chen
May 24, 2023May 25, 2023

ORA-39165 Tried to perform data migration by data pump, but it failed with ORA-39165. [oracle@test ~]$ impdp system@orclpdb schemas=BAR remap_schema=FOO:BAR dumpfile=export_foo.dmp logfile=import_bar.log ... ORA-39002: invalid… Read More »

How to Resolve ORA-39087: directory name is invalid

by Ed Chen
May 11, 2023May 12, 2023

ORA-39087 Saw errors ORA-39087 and ORA-39070, when tried to export data AS SYSDBA through data pump expdp. [oracle@test ~]$ expdp \"/ as sysdba\" full=y directory=BACKUP_DUMPS… Read More »

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
2 Comments

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 »

JavaScript is not enabled. Please enable it and reload the page.