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 data pump import job list

Once monthly we are doing full export of production database and import those data into develop environment. Version of Oracle database is 11.2.0.3 on RHEL 6.4 (64bit). My question is can i get list of those completed import/export data pump jobs,…
prepek2000
  • 1
  • 1
0
votes
1 answer

Oracle SQL - import dump and change data

Im trying to import a database from a dump into oracle, and once the import has completed, I'd like to make some changes to that data. What would be best way to accomplish this? The script below will import the dump file and remap the schema, but…
Sirch
  • 407
  • 3
  • 17
0
votes
1 answer

Export data using DataPump (SQL/PLUS, Oracle)

I need to copy whole schema("ABC") from one host to another one. I'm doing like this: expdp user/pass@host dumpfile=test1.dmp logfile=test1.log schemas=ABC Then I will import this file to my other host. Can you please tell me, if it will copy…
4est
  • 3,010
  • 6
  • 41
  • 63
0
votes
1 answer

LRM-00111 Error importing an Oracle 12 DB

I want to import a Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production hosted in a Windows Server 12 R2, but I got this error: LRM-00111: no closing quote for value ' schemas=O' for all these commands impdp…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
0
votes
0 answers

Oracle 11g data pump export against network filesystem mount

Are network filesytem mounts supported with data pump? I don't see any mention of them not working. However, the data pump ADD_FILE appears to hang. Here are the symptoms: Filesystem Size Used Avail Use% Mounted on /d1 32G 25G 5.4G …
angrycrab
  • 830
  • 1
  • 9
  • 23
0
votes
1 answer

Oracle Datapump API

I am rewriting an application, that imports and exports oracle database. I was using imp.exe and exp.exe executed as Processes from code. Now I'm trying to use impdp and expdp instead of them. I studied some samples at https://docs.oracle.com/,…
Eva Leigh
  • 51
  • 1
  • 9
0
votes
1 answer

Has anyone tried oracle export : EXPDP on the remote machine?

I am trying to export a dump file and log file on a remote machine using oracle expdp. However i am getting the following error : Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning,…
Vaibhav Mhala
  • 33
  • 1
  • 8
0
votes
1 answer

How to dump local .dbm to Oracle database on Amazon RDS

I have local .dbm file and I want to populate it to Oracle Database on Amazon RDS. I am using Ubuntu on my local machine. I don't seem to have a data pump utility. I cannot find option/settings in SQLDeveloper to pump my local .dbm file to the…
user2295203
  • 1
0
votes
1 answer

How to access SSAS datapump url from UNIX box with windows authentication on

I'm trying to access SSAS through the data pump URL (http://SERVERNAME/OLAP/msmdpump.dll) with windows authentication on. 1) I was able to access the data pump URL through olap4j using windows machine. But how do i pass username and password for…
Omal Withanage
  • 85
  • 7
0
votes
1 answer

Switching empty Oracle 12c database to Unicode

I have Oracle 12c installed in a Ubuntu Linux development environment with NLS_CHARACTERSET = WE8MSWIN1252. I want to import a database using data pump that has AL32UTF8 encoding. Is there a convenient way (other than reinstalling Oracle) to either…
laurt
  • 1,811
  • 3
  • 15
  • 18
0
votes
1 answer

NodeJs DataPumps with PostgreSQL: Process Hangs

Hi I started learning node.js three days ago and i have been trying to use datapumps. So far I am running node js with Express and the problem is that my process function never runs. I see this console.log("Ready To Pump"); in the logs so I am…
flexxxit
  • 2,440
  • 5
  • 42
  • 69
0
votes
0 answers

Locked objects while importing dump file

I am trying to import a dump file using impdp Data Pump command. Unfortunately I have a few locked objects. How can I unlock them and proceed with the import ? Thanks in advance. Nikola Neykov
Neykov
  • 21
  • 3
0
votes
1 answer

Oracle datapump export/import

I tried to do a full Datapump exp on our Dbase. But resorted to just backing up the table spaces we were working on. Then I imported using table_exists_action=replace; Afterwards unfortunately all the Grants on objects are lost... grants For…
JohnnyO
  • 527
  • 9
  • 21
0
votes
1 answer

Magmi Datapump API - Item not showing in store

When I add a product with Magmi Datapump API, the product shows up in the Manage Products page but the product is not visible in the store. I open the product in the Manage Products page for editing and just hit save and the product shows up in the…
Emir Ahmetović
  • 63
  • 7
0
votes
0 answers

Oracle data pump using old data

I have an Oracle database that I am migrating data to a new server. Everything is working perfectly, except that for some reason doing an exp uses data from the last time I ran it? I have checked the timestamps of the dmp files and I am definitely…
Michael Jones
  • 33
  • 2
  • 6
1 2 3
…
13 14