Stack Overflow
Stack Overflow

Questions tagged [datapump]

A server based bulk import and export facility in Oracle

Data Pump Export and Import replace Import and Export. It can be used to import or export tables, schemas or entire databases in a dump file.

Questions tagged should also be tagged .

Further reading:

201 questions
4
votes
3 answers

Oracle Data Pump export includes incorrect sequences

Recently, we took a live/online backup of our production database, by issuing the following command: expdp system/******@SID FULL=y DIRECTORY=data_pump_dir DUMPFILE=full_prod.dmp LOGFILE=full_prod_export.log JOB_NAME=prod_backup There were no…
Muel
  • 4,309
  • 1
  • 23
  • 32
3
votes
1 answer

Importing a dmp file created by DataPump into Oracle Express 10g

How do i go about importing a .dmp file created by DataPump into Oracle Express 10g
Alexandre Brisebois
  • 6,599
  • 12
  • 50
  • 69
3
votes
4 answers

Oracle expdp without data

Will there be any impact if expdp is used and the table has no data to be exported? For example, we run a job to perform expdp and the table to be dumped has no records at the instance the job was run, will there be exceptions for this? Should this…
Michael
  • 33
  • 1
  • 3
3
votes
1 answer

Import Oracle Database 12c Enterprise Edition Release 12.1.0.1.0

I want to import a Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production using the command : impdp SOLVIA/SOLVIA900@IMMBO DUMPFILE=week_exp_immbo.dmp LOGFILE=week_exp_immbo.log REUSE_DATAFILES=YES exclude=tablespace:"IN…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
3
votes
1 answer

Oracle datapump export error "invalid argument value"

I have a datapump export script which I'd like to get running. The DB is Oracle 11g. To try it out, I've been executing it in SQLDeveloper. The script looks like this: DECLARE JOBHANDLE NUMBER; STATUS VARCHAR2(20); LOGFILE …
Achim Schmitz
  • 498
  • 1
  • 7
  • 18
3
votes
2 answers

Copy tables containing BLOB columns between Oracle Databases

On adhoc basis, we want to copy contents from 4 of our Oracle production tables to QA/UAT environments. This is not a direct copy and we need to copy data based on some input criteria for filtering. Earlier we were using Sybase database hence BCP…
Swapnil Jaju
  • 432
  • 1
  • 6
  • 14
3
votes
1 answer

How to rename multiple table names with REMAP_TABLE

I have a dump file which contains several tables (A, B, C). How can I rename these tables (A -> x, B -> y, C -> z) during data import?
Meisam
  • 435
  • 1
  • 4
  • 12
3
votes
3 answers

Export sequence in Oracle using "expdp"

I am using the following command to export my sequence to a dump file in Oracle: expdp user/pwd DIRECTORY=user_exp DUMPFILE=morder.dmp include=sequence:HR.EMPLOYEES where EMPLOYEES is my sequence name. However, I get this error: ORA-39001 invalid…
user3400060
  • 299
  • 3
  • 9
  • 23
3
votes
0 answers

Oracle "impdp" the 11g dump file to 12c - Unable to create user during import

I have an Oracle datapump dump file exported from Oracle 11gR2 which has been proven working fine when importing to another Oracle 11gR2 environment. I want to import this dump file to my new environment which is running Oracle 12c. I ran the…
TaoPR
  • 5,932
  • 3
  • 25
  • 35
3
votes
0 answers

Import categories with magmi datapump

This is an example of my category CSV. I never used datapump and I can't find any sample code. I use this code to create a category tree: ini_set('display_errors', '1'); error_reporting(E_ALL); set_time_limit(0); …
Nautilus
  • 41
  • 3
3
votes
4 answers

How to restore dump file in Oracle 12c

I want to restore a database in oracle 12c. I have done something for it but while importing data I got some errors about non-existing users in db.Because the database needs some users which must defined in oracle 12c. I created users for db which…
user3507770
3
votes
2 answers

SQL Server SSIS and Oracle Data Pump

I'm a beginner, and trying to improve my knowledge on DB side. I am learning SSIS with SQL Server 2008R2. Going by the tutorials from Web, I feel like this is somewhat similar to what I've read about Oracle Data Pump. Can someone enlighten me, if…
Justin
  • 102
  • 1
  • 8
2
votes
2 answers

Actual type of a .dmp file

I get .dmp files every so often that I need to load in a database. Some of them are created with datapump and some with exp. Is there a simple way to tell them apart that I could put in a script?
Jon Strayer
  • 2,058
  • 2
  • 20
  • 40
2
votes
1 answer

Unable to remap_data while using datapump export

Could anyone help with my datapump export. I've tried many combinations. But, I'm always getting: ORA-39001: invalid argument value ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4932 ORA-06512: at…
amir
  • 331
  • 2
  • 9
  • 20
2
votes
2 answers

Oracle Datapump Export is very slow

My Oracle 11.2.0.3 FULL DATABASE Datapump Export is very slow, when i ask V$SESSION_LONGOPS SELECT USERNAME,OPNAME,TARGET_DESC,SOFAR,TOTALWORK,MESSAGE,SYSDATE,ROUND(100*SOFAR/TOTALWORK,2)||'%' COMPLETED FROM V$SESSION_LONGOPS where…
Hedi Fourati
  • 31
  • 1
  • 3
1
2
3
…
13 14