Skip to main content

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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
55 views

Oracle Data Pump Export (expdp) how to exit if invalid credentials and not wait to provide valid one?

Execution: Export: Release 19.0.0.0.0 - Production on Thu May 9 07:58:59 2024 Version 19.20.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. UDE-01017: operation ...
Jakub P's user avatar
  • 157
1 vote
1 answer
31 views

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 ...
NEET UI's user avatar
  • 11
0 votes
1 answer
35 views

Oracle 10g impdp without REMAP_TABLE

I have the following question, and I don't know what the best way to proceed would be. I have an Oracle 10g server, and a schema table has become unusable due to operator failures. So I had to do a ...
fah81's user avatar
  • 13
0 votes
0 answers
160 views

while using expdp getting this error

[oracle@oracle197 ~]$ expdp CITI_MDR_DEV_3/CITI_MDR_DEV_3 DIRECTORY=CITIBKP DUMPFILE=CITI_MDR_DEV_3.dmp LOGFILE=CITI_MDR_DEV_3.log Export: Release 19.0.0.0.0 - Production on Sat Mar 16 15:43:35 2024 ...
Ajay Sharma's user avatar
0 votes
1 answer
133 views

Oracle 19c and 21c expdp exports dumpfile of 308kb without any content

Trying to export schema using the following command on several Oracle instances: two 19c and one 21c $ expdp mySchema/myPwd@ORCL Adding CONTENT=ALL or SCHEMA=mySchema or SCHEMA=MYSCHEMA or DUMPFILE=...
Vy8's user avatar
  • 1
0 votes
1 answer
444 views

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, ...
datascinalyst's user avatar
0 votes
0 answers
120 views

Cross Version EXPDP/IMPDP of Indexes

Our source database is 11g and target is 19c. My question is about exporting and importing indexes. Does the EXPDP command "exports" the actual index structure or just the "Create index&...
oradbanj's user avatar
  • 141
0 votes
2 answers
931 views

expdp fails with error ORA-31626 without any details on a full export

I am exporting a complete database (full=y) on oracle 11gR2 on Linux, and always get this error. There are no other messages, so the problem is not about timeout or permissions as shown elsewhere. ...
eppesuig's user avatar
  • 5,052
1 vote
1 answer
763 views

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 ...
Quentin Rey's user avatar
0 votes
3 answers
12k views

export multiple tables using expdp with query condition

I have requirement to export multiple tables using datapump job and the ultimate goal is that we are doing a migration from on-Prem . They have something like 6TB of AUD data and we are not required ...
sarat's user avatar
  • 60
1 vote
1 answer
519 views

EXPDP - why is block estimate significantly larger than segment size?

I'm exporting one specific table for a schema which I thought was a relatively small 5.4 GB SQL> select bytes/1024/1024 MB from user_segments where segment_name='TABLENAME'; MB ---------- ...
Huskie69's user avatar
  • 137
0 votes
0 answers
653 views

Export DataPump - ORA-01555 Snapshot too old

I'm trying to export a customer's production database (schema) for problem solving. During export, I'm getting the following: Estimate in progress using BLOCKS method... Processing object type ...
Huskie69's user avatar
  • 137
3 votes
1 answer
5k views

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=...
Mary Ann's user avatar
0 votes
1 answer
299 views

Issue With EXPDP Full Tablespace

I am trying to export schema with below command using expdp in Oracle 18c XE , the schema uses tablespace named "testtablespace" expdp myschema/*******@//localhost:1521/XEPDB1 schemas=...
ProgNi's user avatar
  • 11
0 votes
1 answer
1k views

What does Oracle impdp do when a name clashes with a materialized view or synonym?

I have a production Oracle database, and I want to export tables, data, views, materialized views, synonyms, etc, to import into a development Oracle database. Actually, this is part of my job, and we ...
osullic's user avatar
  • 101
1 vote
1 answer
552 views

normal Linux user for oracle database dumps

is it possible to allow normal linux user " neither root nor oracle " to be able to execute expdp and impdp and to have access to dpdump directory with rw access on oracle database 12c ? i ...
Seif Hassan's user avatar
1 vote
1 answer
466 views

Using SQL*Plus to connect to remote DB from local server, how do I export a backup to my local server?

I am trying to have my entire remote DB backup made to my local server. Running the following command from my local server: expdp \"user/user@ip as SYSDBA\" full=Y directory=/backup/backup/ ...
Etienne's user avatar
  • 13
0 votes
1 answer
8k views

Oracle DB : Export only table data from from all tables of given schemas

Scenario : I want to export all data(or rows) from all tables from given schemas let say s1, s2, s3 from oracle DB installed on unix server(U1) . This data has to imported on another oracle DB ...
user236778's user avatar
0 votes
2 answers
2k views

Unable to import DMP file that is made in 11g2 to Oracle 18c

My OS=CENTOS 7 Oracle=18c XE I am trying to import a DMP file that is exported from XE 11g2 and now trying to import it in 18c XE. Here are the errors: [root@linux gsw]# impdp user/pass ...
user987376746090's user avatar
0 votes
1 answer
855 views

Datapump not working in RAC environment

Some minutes ago I've tried to do an export but I get the following error (AIX system): Additional information: 3 ORA-31693: Table data object "XX"."TABLE_NAME" failed to load/unload and is being ...
Astora's user avatar
  • 793
1 vote
4 answers
16k views

How to use / as sysdba in pluggable database?

I'm trying to make a export, usually I use userid=\"/ as sysdba\" syntax in Linux command line (I don't know sys password in my production environment. How can I do this using pluggable ...
Astora's user avatar
  • 793
0 votes
1 answer
853 views

EXPDP error ORA-39374 + ORA-13158 Oracle object does not exist

While exporting one of the tables in my db I got the following error : Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS ...
pOrinG's user avatar
  • 125
0 votes
0 answers
471 views

ORA-01466: unable to read data - table definition has changed

What happen when is done a import from a export with this erro? I have a table that every day is altered the structure during the consistent export (flashback_time=systimestamp) and I always receive ...
Astora's user avatar
  • 793
1 vote
1 answer
357 views

Does the target database need to have the same structure of the source database before to use IMPDP?

When I do a import from another database have I need the same estruture of the source database in the target database? For example, if my source database use ASM and my target database no, what have I ...
Astora's user avatar
  • 793
0 votes
1 answer
247 views

Why expdp does not include identified by statement?

I have the following error when I do a impdp (from a pdb in a 12c to 11g. I also used the parameter version=11.2.0) IMPDP LOG: ORA-01938: IDENTIFIED BY must be specified for CREATE USER Failing sql ...
Astora's user avatar
  • 793
0 votes
0 answers
720 views

How can I import the fga_log$ table with impdp Oracle 12 R1

I am trying to import with impdp a save made as follows: expdp '"sys/mmm as sysdba"' full=y COMPRESSION=ALL DIRECTORY=LOGICS_EXPORTS COMPRESSION_ALGORITHM=BASIC LOGTIME=ALL CONTENT=ALL DUMPFILE=FULL-...
miguel ramires's user avatar
1 vote
1 answer
893 views

Oracle expdp command executed in a command file not honoring %U instead using _U without a sequence

I have generated a bunch of expdp commands and stored them in a .cmd file. When I execute one of the commands by copy and paste into a command prompt, it works fine. If I try to execute the whole ....
user avatar
0 votes
2 answers
6k views

Errors using expdp with `flashback_time=systimestamp`

Oracle 11.2.0.1.0 on Windows 2012 Std: expdp '/ as sysdba' full=y directory=exp dumpfile=... logfile=... flashback_time=systimestamp Fails with: ORA-39001: invalid argument value ORA-39150: bad ...
user2847643's user avatar
1 vote
1 answer
2k views

Why doesn't Oracle expdp create the dump file?

I'm trying to export a schema from an Oracle 10.2.0.5.0 database. For some reason, when I launch the expdp command, it finishes almost immediately and it only creates the log file, no dump file at all....
AJPerez's user avatar
  • 121
0 votes
1 answer
3k views

Using JOINS in QUERY clause in EXPDP

I have a par file that is using JOINS in QUERY clause. But it is not working. directory=expdp DUMPFILE=Test_SIT_Query_1table_%U.dmp encryption_password=oracle parallel=8 logfile=TEST_SIT_Query_table....
sabarish jackson's user avatar
1 vote
1 answer
3k views

expdp Hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM in oracle 12c

Expdp Hangs at Below Stage for long time even in structure backup also . Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM Processing object type ...
Ray's user avatar
  • 71
1 vote
1 answer
222 views

Oracle Data Pump Export

If I want to export all the tables in a schema, can I just specify the schema parameter in the parfile or do I also need to list out all the tables individually in the tables parameters? I tried ...
siddhu's user avatar
  • 111
1 vote
3 answers
818 views

Move expdp part file before job end

I have an Oracle 11gr2 database running on Enterprise Linux 6.6 server. I use the following command to split the expdp dump file to 10G size chunks: expdp userid=/ DIRECTORY=dmpdir dumpfile=dump%u....
Ould Abba's user avatar
  • 157
0 votes
1 answer
810 views

Impdp 12c takes table original size

I want to import one of my schema "vvs1" to r&d database with content=metdata_only. expdp works perfect but when i am going to import on r&d server it takes tables original size. for example:-...
Ray's user avatar
  • 71
4 votes
2 answers
21k views

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 ...
Bhaskar Dabhi's user avatar
1 vote
1 answer
9k views

ORA-39001: ORA-39000: ORA-31640: ORA-27041: and Linux-x86_64 Error: 13: Permission denied [closed]

I used this command to export data: expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW Now importing this to other server as: [root@linux gsw]# impdp gsw/password ...
Raakh's user avatar
  • 17
1 vote
1 answer
2k views

Can expdp be piped directly into impdp, without intermediate files?

We often need to copy fairly large databases from one server to another. The current method uses expdp on the source, and then impdp on the destination. This gets pretty horrible because: It takes up ...
Mikhail T.'s user avatar
0 votes
1 answer
659 views

Oracle Transportable Database export ORA-39340: unsupported object, INDEX

I want to get data dump from PDB(Transportable Database). DB version 12.2.0.1.0. Enterprise Edition. Before I get export I applied oracle 27162931 and 27162975 opatch. Then I altered tablespaces ...
Beez's user avatar
  • 1
8 votes
3 answers
67k views

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 ...
Saad Mahmood's user avatar
0 votes
1 answer
2k views

Using Oracle Directories names as same of path

We, at our company, have been using a small hack on Oracle Directories names since some time ago. Before Oracle Directories we have to explicitly set the directory on pfile, by the utl_file_dir ...
Luis Santos's user avatar
1 vote
1 answer
734 views

Pass .csv file as parameter file for expdp Oracle 11.2.0.4.0

Can we use .csv file as parameter file for expdp ? Ex: expdp scott/xxx@dev parameter=table_full.csv Thanks
Hima's user avatar
  • 11
1 vote
1 answer
397 views

Need help on expdp and impdp concept [closed]

I have a multiple databases i.e (database1,database2) and i need to export a table from database1 to database2 . Here are the commands i tried expdp hr/oracle@oracle tables=emp directory = ora ...
Rak kundra's user avatar
0 votes
2 answers
3k views

Is there a way to Oracle expdp not inherit char type nls semantics on DDL?

expdp, by default, generated internal DDL to create table observing current NLS_LENGTH_SEMANTICS of each column. If a column as BYTE (the default and most used) NLS_LENGTH_SEMANTICS, the internal DDL ...
Luis Santos's user avatar
-1 votes
2 answers
6k views

ORA-01555:Snapshot too old error during execution of expdp command [duplicate]

After performing expdp command in production database (Oracle 11g - linux): expdp abc/123 DIRECTORY=data_pump DUMPFILE=SA10_%u.dmp LOGFILE=SA10.log TABLES="abc"."/1FE/019" PARALLEL=4 CONTENT=...
Vnaman's user avatar
  • 17
1 vote
1 answer
1k views

IMPDP from Oracle 10g TO 11g

I'm not able to import the full database from oracle 10g to 11g using impdp FULL=Y. It seems that the file path is differing so what shall I do? The impdp command is looking for oracle 10g path while ...
Sha's user avatar
  • 13
1 vote
2 answers
2k views

Oracle file permissions expdp vs dbms_datapump

We have written our own export function using calls to dbms_datapump. In some systems the export fails due to insufficient file permissions on the chosen directory. However, using expdp to perform ...
Rene's user avatar
  • 121
0 votes
2 answers
17k views

Oracle full expdp/impdp but skip data in some tables

I'm trying to export a schema and then import it, but there are some huge tables that I must skip all the data from (that is, I need the tables and all stuff related to them, just not the rows). So I ...
FORTRAN's user avatar
  • 235
1 vote
1 answer
397 views

Error in database export

I'm using Oracle 11g databse. For logical backup, we are exporting database on daily basis using below command and dump size is almost 12GB. , but now I'm facing an issue with my expdp. expdp 'sys/...
akr's user avatar
  • 141
0 votes
1 answer
1k views

ROWID and expdp

Can anyone please tell me if ROWID is also exported in expdp process ans stored in dumpfile. Can I use the following while importing? QUERY=table_name:\"WHERE rowid = (select min(rowid) from ...
Bibhuti Bhusan Padhi's user avatar
2 votes
1 answer
9k views

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. ...
akr's user avatar
  • 141