Questions tagged [datapump]

Oracle Data Pump is a set of command line utilities and PL/SQL packages for moving data and metadata between Oracle databases.

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
79 views

Oracle Database 19.3 on Windows: Howto impdp or expdp from a UNC path in Windows?

With oracle database release 18.3 it is possible to use a unc path as a directory in windows and pump a database pump from this directory with impdp. Example: C:\>sqlplus system/passwd@exampledb ...
1
vote
0answers
2k views

Import Dump: Cannot Locate Master Table

I'm trying to import a dump file with the command below: impdp system/password dumpfile=mw0sd1.dmp keep_master=Y But it returns following error: ORA-39002: invalid operation ORA-39059: dump file ...
1
vote
1answer
3k views

How do I kill Oracle DataPump expdp job stuck in DEFINING state?

My job failed because dump file already existed. Now it's stuck in DEFINING state. How do I stop/kill it? declare h1 number; BEGIN h1 := DBMS_DATAPUMP.ATTACH('EXPORT_TABLE_2017_1205_1402',user); --...
1
vote
0answers
132 views

Get current-processed column information in Oracle datapump

In order to mask data I am using REMAP_DATA parameter in Oracle datapump as follows: expdp \'/ as sysdba\' DIRECTORY=DUMP_DIR DUMPFILE=dumpfile.dmp LOGFILE=logfile.log SCHEMAS=user0 REMAP_DATA=user0....
1
vote
0answers
403 views

Function can't drop synonym

I am debugging an application that is working correctly on many PCs but not on one particular one. The part of the application that is having an issue is an automated restore using dpimp from another ...
0
votes
1answer
58 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....
0
votes
0answers
212 views

Oracle impdp only imports one schema from a dump into which expdp exported many schemas

I have the following problem and doubt in Oracle. I am trying to import with impdp a dump from my database into which I exported several schemes. The problem comes when I try to import into the same ...
0
votes
1answer
73 views

Oracle Datapump between different database releases

I need to transfer schemas from a Oracle 12.1.0.2 Database to a Oracle 11.2 XE Database. Accodring to Oracle Docs: On a Data Pump export, if you specify a database version that is older than ...
0
votes
1answer
1k views

Oracle 11 IMPDP Table Exists but gets Does Not Exist Error

I'm running in to a weird problem with IMPDP and Oracle DB version 11.2.0.4.0 where I have a table in the destination schema that does indeed exist, but IMPDP thinks it doesn't. See this entry from ...
0
votes
0answers
391 views

Datapump Import Parallel execution

I have noticed differences in executions between data pump imports lately, and I am trying to determine what is causing the differences. I am using impdp to move data between databases, and remap the ...
0
votes
0answers
975 views

Issue COMMIT in between impdp process

I am using Oracle DBMS_DATAPUMP API to import a dumpfile containing some table data. Is it possible to stop the job and issue COMMIT; in the same session to maybe cleanup UNDO tablespace and then ...
0
votes
0answers
1k views

Extremely slow datapump imports from 10.2.0.1.0 -> 11.2.0.1.0

All imports/exports talked about here are using datapump, the 10.1.5 system is running on Windows Server 2003 and the 11.2 system is running on Linux. I have an 11gig datapump dumpfile from a 10.1.5 ...
0
votes
0answers
1k views

Partition table data into dump files in a single command

I have a fairly large table of spatial data. Because it is spatial data, I have discovered that data pump uses a very large amount of space to import it. (I have seen it use approximately 40 GB of ...
0
votes
0answers
4k views

Importing dump file contents to another DB with different schema using Oracle Data Pump

I asked this question in stackoverflow but no one was able to answer it so am trying my luck here if anyone knew what am talking about. Here is the link original question. What i wanted to do is to ...
0
votes
0answers
4k views

Oracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00

I'm trying to use data pump to move the database to a different server with this command: impdp dbuser/dbpsw@dbserver directory=data_pump_dir network_link=sourceDB schemas=EMP But I got this error: ...
-1
votes
1answer
702 views

Restore a dump file from a different server, with a different name

I Expdp a user with the name user_prd for example. I copied the dump file to another server, and I want to restore it with the name user_hom. I tried remap_schema with no succes ( Im a SQL DBA, so it'...