Question : I have been given a DMP data pump export file to import into my local Oracle instance. I’ve […]
Tag: impdp
ORA-00959: Tablespace ‘$name’ does not exist when using impdp
Question : I’m new at Oracle databases. I’m executing an impdp command and encountered this error: ORA-00959: tablespace ‘$name’ does […]
Export from Oracle 10g and import to Oracle 12c unable to create users
Question : I have and old install of Oracle 10g with a lot of users and tablespaces in it, for […]
ORA-39002, ORA-39168 on IMPDP, Object path GRANT was not found
Question : I’m trying to impdp a schema with just one table on it. The impdp parfile looks like this: […]
Oracle migration unable to create indexes
Question : I want to move the contents of a database instance to another using the expdp and impdp utilities. […]
Are expdp/impdp commands appropriate for daily schema sync?
Question : I’ve done following comands: expdp system/password@localdb ^ schemas=SCH directory=dumps_dir dumpfile=SCH_%date%.dmp logfile=expdpSCH_%date%.log It runs great, without errors. But when […]
impdp schema name not found
Question : I have Oracle Database 11.2.0.4. I want to import a dump file to it with impdp. The Dump […]
Oracle Data Pump, pause a job
Question : I currently have a impdp job running for a fairly large schema (2TB) and ran into an error. […]
How can I identify and fix bottlenecks in an Oracle11gR2 import
Question : I’ve recently been tasked with moving our Oracle 11g database from a linux CentOS desktop to a windows […]
Exporting from Oracle enterprise edition to standard edition reaches schemas limit
Question : So, I’m trying to export an oracle database(10.2) from EE to SE over a networklink. It all works […]