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

How to impdp ? Oracle Multiple Dump File with their Corresponding Tables

I am trying to import the data from dump file , so I created the test.par file which contains multiple dump file for each table and in the below table parameter I have mentioned the table name correspondingly. Test.Par …
GaneshBen
  • 33
  • 9
0
votes
1 answer

how to import a dmp file with profiles from a CDB db to a PDB DB instance using impdp in Oracle 12c?

I have a dmp file from a CDB(don't know exactly) in another server from where, I was given a dmp file which was exported using expdp(possibly). I want to import it into a PDB instance on an Oracle 12c server which I have. I extracted the sql file…
Jithu Paul
  • 154
  • 2
  • 15
0
votes
1 answer

Export and Import using Data Pumps in Oracle 19c

I have a table in which I want to add a new char type column Before adding the column took the export , then dropped the table and then recreated the table and then did the import using the same dump file. When I checked the value of new added…
Niket Agrawal
  • 1
0
votes
1 answer

How to health check oracle docker container where import (impdp) of data is running

I have a oracle docker container where import of dump has to run using impdp command. After the import has finished successfully with no errors, the container should become healthy and next process should start. Is there a way to define some…
john.michael
  • 57
  • 4
0
votes
1 answer

Oracle Import Data dump: tablespace: "USERS" already exist

I am trying to import data using impdp in oracle. However, when I tried to import it, it is giving me the following error: ORA-29349: tablespace "USERS" already exists Since USERS is the defualt permenant tablespace that contains users objects, I…
AngryOtter
  • 149
  • 9
0
votes
1 answer

Oracel DB Move huge size partition using transportable tablespace in shell script

we have a huge DB with daily 20Mil records, We have an interval partitioned table on creation time column(filled with Sysdate at before insert trigger) As this data are important and cannot be purged and storage runs out after some time, We have…
hmmftg
  • 1,274
  • 1
  • 18
  • 31
0
votes
1 answer

dump file oracle 11 docker

I used docker oracle database Oracle Database 11g Express Edition Release 11.2.0.2.0 I tried to import a file dmp, but i have the bellow error docker-compose.yml version: '3' services: oracle: image: jaspeen/oracle-xe-11g container_name:…
Aymen Kanzari
  • 1,765
  • 7
  • 41
  • 73
0
votes
0 answers

Imported table from datapump utility is of less size and have fewer rows than it was exported?

I have a data dump file which was created through EXPDP utility in oracle 11g. The log file of export is as: ;;; Export: Release 11.2.0.4.0 - Production on Fri Oct 30 19:00:03 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All…
chandersheel
  • 35
  • 6
0
votes
1 answer

How to analyze oracle dump file

I need to analyze a large Oracle DMP file. So far, I have no experience with Oracle. I know that the database contains information about certain people, for example a person with the name Smith. I don't know how the database is structured (which…
wiegehtdasblos
  • 11
  • 1
  • 4
0
votes
2 answers

How to use IMPDP Oracle Database on MacOS

Im trying to import my oracle database by using IMPDP on MacOS, I've dump file, and SQLDeveloper app already. But it return IMPDP: command not found. It seam cannot use it in Mac? How can I use it or any way to run my dump file? Regards.
Phương Thảo
  • 27
  • 5
0
votes
1 answer

ignored fields when importing data using impdp

I am trying to load it massively in my database and I noticed that by doing the following command if the table is empty it loads without problems, but if it has 1 record it ignores the entire table. am I using any parameter incorrectly? impdp '/ as…
RC LFA
  • 19
  • 6
0
votes
1 answer

Load millions of rows using impdp into a table in parallel mode with trigger installed (Oracle)

I am trying to load millions of Rows using impdp into a Table in parallel mode: impdp .... parallel=10 The trigger On that table "before insert trigger" should replace some values. Is there any way to execute the trigger in parallel mode too?
sandro98
  • 29
  • 6
0
votes
1 answer

How do I export a schema with all data to my local instance on my PC (Oracle XE)

The Server is Oracle 11g 11.2.0.4.0 The local instance of my Oracle is "Oracle Database 18c Express Edition Release 18.0.0.0.0" I want to export the schema called "AlphaTest" and all it's associated triggers, tables, views, packages, etc and import…
software is fun
  • 7,286
  • 18
  • 71
  • 129
0
votes
1 answer

Oracle 12c import dump with user profiles & roles

I'm trying to import dump file I received from customer. The customer defined the schema on user with Profile and Role which obviously do not exist in my Database and are not required by me. Whenever I do impdp I get multiple errors: ORA-02380:…
Michal
  • 11
  • 1
  • 4
0
votes
1 answer

AWS RDS datapump directory to be used

I know nothing much about aws. Could you help to resolve the issue. I need to take a dump of my Database in AWS Oracle RDS, so trying a command which is shown below expdp ***/****@WINDMIG5 schemas=agTransform directory=/rdsdbdata/datapump…
XSL Query
  • 11
  • 4
1 2 3
…
11 12