Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [impdp]

For questions about the Oracle Data Pump Import (invoked with the impdp command). Use together with the [oracle] tag, and include the appropriate version tag, such as [oracle-12c]. If the question applies to both the impdp and expdp commands, do not use this tag; use [datapump] tag instead.

The command line utility impdp uses the Oracle DataPump framework to import proprietary dump files created by the expdp commands to restore data from an export. See the page for more information on DataPump.

93 questions
29
votes
2 answers

How to transfer data using expdp and impdp commands?

I'm an Oracle noob, and my intention is to transfer all data and metadata from one schema to another schema within an Oracle database. I'm planning to use datapump's expdp and impdp commands. I have questions regarding this: Can I create a target…
jrara
  • 5,393
  • 20
  • 58
  • 65
9
votes
3 answers

How to replace and overwrite all existing objects in Oracle with impdp for full database import?

I want to replace all the existing objects in my database, not just tables, into my current database. I ran expdp with the parameter full=yes as the system user, who I granted datapump_imp_full_database while logged in as sysdba, from the instance I…
Saad Mahmood
  • 91
  • 1
  • 1
  • 2
8
votes
1 answer

How to find the schema name of a data pump dmp file?

I have been given a DMP data pump export file to import into my local Oracle instance. I've tried running this command line: impdp full=Y directory=DATA_PUMP_DIR dumpfile=MyDumpFile.dmp logfile=import.log I get the errors: ORA-31655: no data or…
Shaul Behr
  • 2,963
  • 8
  • 34
  • 42
8
votes
2 answers

impdp stuck on index import

impdp import is stuck on: Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX How can you debug this?
Marcus Leon
  • 183
  • 1
  • 1
  • 5
5
votes
1 answer

Trying to copy a schema using impdp

I'm trying to copy a SCHEMA in its entirity using oracle's IMPDP tool. I've setup a database link back to itself and the link works fine. Then I'm running this: impdp username/password@instancename schemas=TARGET_SCHEMA …
rfusca
  • 1,569
  • 4
  • 17
  • 29
3
votes
1 answer

Oracle IMPDP job ORA-30036 unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

I'm using IMPDP with the "network_link" for perform export/import in a single-pass. It runs fine until I get this error. ORA-39171: Job is experiencing a resumable wait. ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' Here…
Stringer
  • 312
  • 1
  • 3
  • 9
3
votes
1 answer

Oracle: Full database (user) restore requires drop?

In our development environment (Oracle 11g), we often have to restore databases (users) to previous versions to test upgrades, verify defects, etc. We are using expdp/impdp to perform our backup/restores. For back-ups we run... expdp…
Tony
3
votes
1 answer

ORA-39014 import in Oracle 19c from DMP file of Oracle12c

I have been testing out expdp/impdp of databases from 12c to 19c( newly created database) but one db have game me this error: nohup impdp system/****@CKLPROD CONTENT=METADATA_ONLY PARALLEL=4 DIRECTORY=DATA_PUMP_DIR…
Mary Ann
  • 43
  • 1
  • 8
3
votes
1 answer

How to Import an Oracle dump version 5.1 into 12c?

I have .dmp files exported as version 5.1 and I need to import them on an Oracle 12c. I have no access to the original database to re-export setting the VERSION parameter. This is the error I get: ORA-39001: invalid argument value ORA-39000: bad…
fccoelho
  • 153
  • 2
  • 2
  • 6
3
votes
2 answers

Sequence number shows a lower value after dump file import

I'm using Oracle 11g database in which I have more than 12 schema's consisting of many tables. I've created sequences for primary keys to these tables. I've also created synonyms to refer my application from the main schema. My issue is, while i…
SHS
  • 152
  • 2
  • 5
  • 14
3
votes
1 answer

Oracle Data Pump, pause a job

I currently have a impdp job running for a fairly large schema (2TB) and ran into an error. The source database has one column that is larger then the destination database. This is causing ORA-02374 and ORA-12899 errors. This has caused the…
Patrick
  • 698
  • 3
  • 9
  • 23
3
votes
3 answers

Oracle 12c: installing expdp and impdp on Linux

The default Oracle installation for Linux didn't come with the expdp and impdp command line tools. I have trouble finding them on Oracle's website. How could I install them?
laurt
  • 233
  • 2
  • 3
  • 10
3
votes
2 answers

How to debug an hanging impdp importation

I am currently trying to import a database dump in Oracle XE 11gR2 On windows 7. I have the following command. impdp 'APPLICATION/APPLICATION@XE' dumpfile=APPLICATION.dmp REMAP_TABLESPACE=APPLICATION:USERS logfile=APPLICATIONIMPORT.log I tried…
Laurent Bourgault-Roy
  • 141
  • 5
2
votes
0 answers

Fast restore of dropped partitions

I want to test the restore of erroneously dropped partitions of a subpartitioned table. This restore would consist of three steps: restore the database (or at least the necessary tablespaces) to the needed point in time to a different…
miracle173
  • 7,797
  • 28
  • 42
2
votes
1 answer

Oracle expdp et impdp : order of schemas?

When I try to export and then import many schemas from one Oracle DB to another one, I get errors because grants and synonyms cannot be recreated in the target DB; the reason is probably that the schemas are not imported in the right order. So…
Pascal Sartoretti
  • 21
  • 3
1
2 3 4 5 6 7