Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [expdp]

For questions about the Oracle Data Pump export (invoked with the expdp 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 expdp uses the Oracle DataPump framework to export proprietary dump files of database data. The ouput files can be imported by the impdp commands to import that data into the same or a different database. See the page for more information on DataPump.

68 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
4
votes
2 answers

How to export oracle database version 12.1.0.2.0 with expdp Release 12.2.0.1.0

I am running following command to dump my database ./expdp username/password@//host:port/database directory=/home/ubuntu/oracle/instantclient_12_2 dumpfile=dumpfilename.dmp content=METADATA_ONLY and getting following error Export: Release…
Bhaskar Dabhi
  • 141
  • 1
  • 1
  • 2
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
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
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
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
2
votes
2 answers

Expdp error UDE-22303

I am experiencing the following error, when I am trying to make an export to the database using expdmp utility: UDE-22303: operation generated ORACLE error 22303 OCI-22303: type "SYS"."KU$_STATUS1020" not found Do you have any idea what can cause…
Julya
  • 29
  • 1
  • 4
2
votes
1 answer

Consistent Database Export of Oracle Database

I'm quite confused and I need some clarification! I do full export of database with Export Pump (for replication/duplication). What I usually do is: SQL>SHUTDOWN IMMEDIATE SQL>STARTUP RESTRICT Then export, so I can have a consistent export…
Data-Base
  • 357
  • 2
  • 12
  • 21
2
votes
1 answer

Datapump export taking too much time to complete

I've scheduled to take a backup of my oracle11g database, daily at 11pm via Windows Task Scheduler. At this time, I'm not letting my database to go down. Also, my database is in noarchivelog mode. Although my dump size is 7GB only, this export is…
akr
  • 141
  • 2
  • 7
  • 15
1
vote
1 answer

impdp syntax for schema that is not available on other database

My intention is to import the data of schema 'SCOTT'. I have exported it from db1 using expdp scott/tiger schemas=scott dumpfile=scottexp.dmp ...... Now When I try to import the same in database db2 what would be the syntax. I don't have the SCOTT…
Newbie-oracle
  • 11
  • 2
1
vote
2 answers

Oracle Full Client / Database Client package locations

I need to install multiple versions of the Oracle client on an app server for an automation project. The platform I'm looking for in specific is Linux, 64 bit. Oracle's network of websites are a maze and not helpful at all. Here is what I've…
Avindra Goolcharan
  • 115
  • 1
  • 1
  • 6
1
vote
1 answer

Tryting to export data from one table but got error

I'm new to database export/import stuffs (as I'm not DBA), and I'm recently tasked to develop a housekeeping script which include the export data pump (expdp) subtask. But for some reasons, when I run expdp command and check the log file, it…
NEET UI
  • 11
  • 2
1
vote
1 answer

Unable to import constraints using IMPDP in Oracle 19c

I am using impdp user/password@PDB directory=data_pump_dir tables=tablename dumpfile=DP_3.dmp logfile=card.log parallel=6 there are 2 tables: Table A and Table B the tables are restored correctly, but for some reason, the constraints are not…
datascinalyst
  • 105
  • 2
  • 11
1
vote
1 answer

Oracle12c - EXPDP hangs when using NFS share

I have a problem with the export via EXPDP for Oracle12 databases. When the export is local, no problem. When I use an NFS share, the export starts, creates the log file, then nothing. VM where the database is located: Oracle Linux Server -…
Quentin Rey
  • 11
  • 6
1
2 3 4 5