DUMPFILE

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 LRM-00109: could not open parameter file

by Ed Chen
June 30, 2021February 3, 2022

LRM-00109 We usually put most parameters in a PARFILE for routine data pump operations, but you might see LRM-00109: could not open parameter file. in… Read More »

Network Link May Not Work When Importing Partitioned Tables

by Ed Chen
December 21, 2016August 22, 2018

I found I can't import partitioned table via NETWORK_LINK.[oracle@test ~]$ impdp system/password tables=sh.sales content=data_only table_exists_action=truncate network_link=system_link_orclImport: Release 11.2.0.4.0 - Production on XCopyright (c) 1982, 2011,… Read More »

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