Stack Overflow
Stack Overflow

Questions tagged [impdp]

Oracle Data Dump is a newer, faster and more flexible alternative to the exp and imp utilities used in previous Oracle versions. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables.

166 questions
10
votes
5 answers

How to change Oracle default data pump directory to import dumpfile?

I'm using impdp to import a backup. But I want change default directory dumpfile. $ impdp system/password@$ORACLE_SID schemas=USER_SCHEMA dumpfile=mydumpfile.dmp logfile=impdpmydumpfile.log Import: Release 11.2.0.3.0 - Production on Mon Mar 16…
acfreitas
  • 1,347
  • 2
  • 13
  • 27
10
votes
2 answers

Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?

One can use the Oracle data pump import tool (IMPDP.EXE) to import one schema into another using the REMAP_SCHEMA option. However there is an issue in that triggers are not properly remapped. This leads to the trigger not being created at all with…
VinceJS
  • 1,254
  • 3
  • 18
  • 38
8
votes
4 answers

ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings

When I'm trying to run impdp command in sqlplus, I got below error. ORA-31631: privileges are required ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings. I have granted IMPORT FULL DATABASE privileged to schema which I'm trying…
Bishan
  • 15,211
  • 52
  • 164
  • 258
7
votes
3 answers

Configure Dockerfile to use impdp command when the container is created

I am using wnameless/oracle-xe-11g docker image to create a new image file. And when I create a container from the new image I want the impdp command to be executed. How can this be achieved via Dockerfile? Here is my Docker file Dockerfile # Base…
Trying-to-learn
  • 341
  • 1
  • 3
  • 9
7
votes
1 answer

Oracle data pump impdp to remote server

We have a dump file that we want to import to an Amazon rds server. This is what I did: Create a public db link and verify it works: create public database link rdsdblink connect to dbuser identified by dbpsw using…
Cal
  • 747
  • 1
  • 13
  • 30
6
votes
5 answers

Importing selective data using impdp

I have an entire DB to be imported as a dump into my own. I want to exclude data out of certain tables(mostly because they are huge in size and not useful). I cannot entirely exclude those tables since I need the table object per se(minus the data)…
atlantis
  • 3,056
  • 9
  • 30
  • 41
6
votes
3 answers

How to export users in Oracle with its roles and system privileges using expdp?

I am trying to export a schema/user in Oracle with its roles and system privileges. I don't want to export any data or any table. I have tried to export users using the following command. expdp system/system@gisdblocal include=user DIRECTORY =…
Ayaz49
  • 325
  • 2
  • 4
  • 18
6
votes
1 answer

impdp in Oracle. Why it does not create users?

I am newbie in oracle and I am facing troubles with impdp. I have a production server and I have created a new server for testing purposes, so I installed centos, oracle and created the database "sire". Now I make a dump from the production server…
Carlos Antidio Morales
  • 95
  • 1
  • 1
  • 3
5
votes
2 answers

Oracle impdp running way too long

I'm trying to import a schema into an oracle instance, that's running in a docker container (hopefully this is not relevant). I would like to apologize in advance for the long post, but I wanted to include all I have already checked. The import…
pagerbak
  • 93
  • 1
  • 1
  • 6
4
votes
1 answer

Oracle import dump file throwing ORA-39088 error

I am trying to import data from a dump file created by Oracle 10g data pump utility. The command that I am issuing is impdp \"username/password@DB as sysdba\" remap_schema=SRC_SCHEMA:TARGET_SCHEMA…
user170008
  • 1,046
  • 6
  • 17
  • 31
4
votes
4 answers

Migrating Oracle Database with expdp and impdp

Does the target database need to be prepared with tablespace and/or user (schema) in order to successfully migrate a schema from one database (11g R1) to another (11g R2)? Currently I only can make tests with the 11g R1 database. My test was to…
Christian Ammer
  • 7,464
  • 6
  • 51
  • 108
4
votes
1 answer

import and remaping tables without adding primary key and indexes

I am trying to import a dump to a database. the dump has a table called table1 which already exists in the database , that I was I used remap_table. impdp schema/pass@server remap_table = table1:table_BR1 directory=TEST_DIR1 dumpfile=table_BR1.dmp…
Baalback
  • 387
  • 7
  • 20
4
votes
2 answers

Using impdp/expdp with RDS Oracle on AWS

I'm very new to Amazon web services, especially using their RDS system. I have set up an Oracle database (11.2) and I now want to import a dump we made locally from our server using expdp. Apparently, the ability to use expdp/impdp on AWS is quite…
BlackLabrador
  • 2,829
  • 5
  • 18
  • 21
3
votes
1 answer

How complete is an Oracle11g IMPDP?

I was given the task of upgrading to a new Oracle Database Server (11gR2). The former DBA gave these instructions: Use Embarcadero to export Roles from Old and execute SQL on New Server Use Embarcadero to export Tablespaces from Old and Execute SQL…
user739866
  • 891
  • 1
  • 9
  • 18
3
votes
1 answer

How to download and import a dump directly into your oracle Docker image?

I am quite new to docker technology and still learning and reading through the docs. I have an oracle base image which i would like to use as a parent image to build my own image and then pushing it towards custom docker registry/repository. The…
john.michael
  • 57
  • 4
1
2 3
…
11 12