The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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.

Filter by
Sorted by
Tagged with
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
423 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
1k 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
1answer
106 views

Oracle 11.2 restore DB to a specific point

I should execute following tasks: 1. test system and during test change Oracle data and Create New/Remove Old datafiles and tablespace. 2. at the end of test rollback to behviour before of point 1. I'...
0
votes
1answer
37 views

Is it possible to drop export some shema without data and the other with data

I have oracle 11G R2 under RHEL 6.3 test is the name of the database, the database contain 12 custom schema, sch1,sch2,...,sch12. is it possible to create database backup using datapump method that ...
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
1answer
3k views

Using environment variables in data pump query

I have been trying to use data pump (expdp and impdp) in order to retrieve some data from a database to import it into another. I am using the expdp using the table and the query parameters in order ...
0
votes
0answers
5k 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
1k views

ORA-01555: snapshot too old: rollback segment too small

We see this error on a number of tables when doing an expdp on 12c / Windows. A restart of the Oracle database service makes this go away... Can anyone shed some light on what may cause this and the ...
-1
votes
1answer
773 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'...
-1
votes
1answer
249 views

Datapump export

I'm trying to export the full database using the datapump API, I tried to use this following code: DECLARE handle NUMBER; nom_job varchar(25) := to_char(SYSDATE,'YYYYMMDD_HH24MISS'); nom_dump ...
-2
votes
1answer
84 views

importing 50gb+ dmp using imdp

Attempting to import 50GB+ dumpfile using impdp. Hitting the 11GB datafile limit. Never used oracle before. I created bigfile tablespace with autoextend on. Perhaps I should use different approach?