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
0
votes
0 answers

Oracle SQL developer error while Export Dump "DBA Privileges Required "?

I have given grant access to my DB, but still its showing as DBA privileges required to export the Dump
Sri Balaji
  • 1
  • 1
0
votes
0 answers

Oracle 12c Import LRM error

I have 2 different Oracle servers. And I will do migration from 11g to 12c. I am doing prova now. These 2 servers has a network mapped connection on folder. I got full export from 11g to this shared folder successfully but when I trying to import I…
user7139872
0
votes
1 answer

Export/Import Data Pump when tablespace is in different path

I need to do an export data pump of schema TESTE from server A and import on server B (OS Linux). I pre-created a tablespace in server B but in server B, I have ASM. My question is, can I have some problem during import, like "tablespace not found"…
haley
  • 3
  • 2
0
votes
1 answer

What happens to existing tables during import using impdp

I want to export and import an entire schema from Prod to Dev, but Dev has already existing tables (that are not there in Prod) which I don't want to be affected. So, the question is during import (impdp) what happens to those existing…
vignesh28
  • 1
  • 5
0
votes
0 answers

Oracle to delimited file in HDFS?

I am working on a solution to transfer data from Oracle to HDFS. I looked into datapump, but there seems to no integration with HDFS. Another way would be looking into sqoop. But there are latency concerns with both the approaches. Are there any…
VoodooChild
  • 400
  • 1
  • 6
  • 18
0
votes
0 answers

How to set the datapump path in the database dynamically?

Actually data pump requires the dump directories to be set in the database. I need to set a data pump path dynamically. Also without overwriting the existing dump files. Something like this: Echo(Create Directory xxdmp AS '/opt/oracle'; Echo Grant…
Arjun7567
  • 1
  • 4
0
votes
2 answers

Oracle - Error ORA-00907 using remap_data parameter with datapump export

I'm trying to export data with the remap_data parameter (datapump mode) in order to hide some data. This works fine with "varchar2" or "number" column but fail with "long" column. In the export log file we can see the ORA-31693 error then the…
Tribe
  • 1
  • 1
0
votes
1 answer

Can't import dump from mapped net drive using data pump

I'm trying to import few users from .dmp file from a net drive. Unofrtunately it seems that I lack some rights to do so since I get ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open dump file…
Hisu
  • 95
  • 4
  • 13
0
votes
1 answer

import and export using impdp/expdp in oracle10g/11g

I have two databases, one is production and second is a test. I want to export from production database and import into test database. My production db contains many users/schema out of which only few (<10) schemas contain actual objects. First…
orcluser
  • 1
  • 1
  • 1
  • 2
0
votes
1 answer

Data Pump Incremental Export

I have to perform a incremental export in oracle using Data Pump API. I read somewhere that Data Pump API does not support incremental backup. Is there any alternatives to this? I have to perform the export using the Data Pump API.
Saroj
  • 71
  • 2
  • 11
0
votes
0 answers

How to format pumped file in Oracle SQL Developer in any way?

My problem is that I unloaded a table from Oracle db into a text file with the following code: PACKAGE BODY: procedure d_datapump (tab_name in varchar2, def_dir in varchar2 default 'MY_DIR', xt_location…
A117
  • 319
  • 1
  • 3
  • 8
0
votes
1 answer

Metadata Filter in Data Pump API

How to exclude all INDEX,GRANT,SYNONYM,CONSTRAINT while exporting data using Oracle Data Pump API (DBMS_DATAPUMP package)?
Saroj
  • 71
  • 2
  • 11
0
votes
0 answers

Oracle Data Pump Export

I am trying to perform Oracle Data pump Export (using API) over a network link on a server running linux. When I run the API I get the following error: ORA-31693: Table data object TABLE NAME failed to load/unload and is being skipped due to…
Saroj
  • 71
  • 2
  • 11
0
votes
0 answers

Data pump "impdp" fails with error message saying "unable to extend the table"

Background I am trying to import a huge Oracle database dump whose size is larger than 40GB to my Oracle Express environment. As you know, Oracle Express does allow only up to database size of 11GB. Therefore, I can't "impdp" the entire bulk of this…
TaoPR
  • 5,932
  • 3
  • 25
  • 35
0
votes
1 answer

Datapump export and import 5Gb table

In oracle 10g, In Data Pump I am Exporting and Importing a 5GB table from source to destination. In the 5Gb table the data is added and some rows are updated. This time I need to only export and import changed data and updated data, but not the…
Praveen Kumar
  • 1
  • 2
1 2 3
…
13 14