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
2
votes
1 answer

Oracle impdp : UDI-00013 Message 13 not found

Using Oracle impdp I'm getting error message: UDI-00013 Message 13 not found No message file for product=RDBMS, facility=UDI How can I correct this?
user840930
  • 5,214
  • 21
  • 65
  • 94
2
votes
2 answers

Return code/ exit code for Oracle's DataPump API

I wrapped oracle's IMPDP and EXPDP in a console and could not find a good place for the return codes that these two return. I want to be more specific in pointing out errors than just a 0/1 Pass/Fail.
Shravan
  • 223
  • 1
  • 5
  • 12
1
vote
3 answers

disable/decrease the generation of archived redolog files while importing

We have a shell script that we use to import a dump file into a database. This script literally calls impdp utility. But before doing so, it disable the Archivelog on the target database in order to disable generation of archived redolog files…
SamiBOB
  • 243
  • 4
  • 12
1
vote
1 answer

Slow import of data using impdp for index organized tables in oracle..is there a way around?

I have a table of around 50G which i want to move into another environment. the method we chose is to export the data from a source IOT table using expdp create a temp IOT table without secondary index use impdp with the below command. The issue I…
BVAD
  • 75
  • 2
  • 6
1
vote
0 answers

Could not execute impdp command from docker exec command

I have an oracle 12 docker container where i executed the command "impdp" from docker exec command to import data, but it fails. The error says: UDI-01089: operation generated ORACLE error 1089 ORA-01089: immediate shutdown or close in progress - no…
john.michael
  • 57
  • 4
1
vote
1 answer

Oracle XE 18c impdp dump from 19c

I have a dump file that is created using expdp from Oracle 19c (exported with version parameter 18). Is it even possible to import the dumpfile to an Oracle 18c XE database? The structure and everything else from the 19c database is unknown to me. I…
Marc Jansen
  • 11
  • 5
1
vote
1 answer

how to resolve thousand of errors in oracle import using impdp where I don't know the what parameters were used during expdp?

I am trying to import an oracle 11g dump file using impdp utility but while doing so, inter alia, I am facing two major errors: First, It is showing the following error: Processing object type DATABASE_EXPORT/TABLESPACE ORA-39083: Object type…
chandersheel
  • 35
  • 6
1
vote
1 answer

Monitor system resource consumption during imdp in oracle RAC

I need to import with impdp to my RAC database (Oracle18c, 3 physical nodes and RHEL7) and I would like to monitor the consumption of resources (cpu, ram and disk) of the 3 nodes, leaving something like a report in a file during the import process.…
miguel ramires
  • 13
  • 2
1
vote
1 answer

Translate oracle-dmp with data into sql file

I want to create an SQL file from an Oracle DMP file. With the command "impdp [system] / [password] DUMPFILE = dampfilename.dmp SQLFILE = sqlfilename.sql logfile = logfilename.log full = Y show = y" only the structure is in the sql file. When I look…
wiegehtdasblos
  • 11
  • 1
  • 4
1
vote
1 answer

Remove entire data from Oracle XE because it's full

I take the liberty of asking you because I have a problem with Oracle XE. I use the free version which allows me to store 12GB of data. I receive a dump every week, the imports worked well but the 12GB are exceeded and I cannot launch any more…
Stoufiler
  • 175
  • 1
  • 2
  • 13
1
vote
1 answer

How to import dmp file to oracle DB via SqlDeveloper or CMD in windows?

I have an Oracle dump file that got exported from an unfamiliar database. I need to import it to my Oracle DB with either SqlDeveloper or command line in windows. When using Data Pump Import Wizard in SqlDeveloper I'm getting the below…
user1508682
  • 1,329
  • 5
  • 23
  • 34
1
vote
3 answers

Impdp ora-00904 invalid identifier

I'm triying to import our database which is in WE8MSWIN1252 instance to a new AL32UTF8 instance. I'm using impdp tool to achieve this. I get the following error Processing object type …
Bilel Chaouadi
  • 903
  • 1
  • 10
  • 28
1
vote
1 answer

Downloading oracle RDS table data to a local database

I have an Amazon Oracle RDS database. I would like to export the RDS table and import it to my local database. The kicker is that it includes a NCLOB column. The local system is Win10 running Cygwin. I run expdp to capture the data: $ expdp…
wdtj
  • 4,554
  • 3
  • 17
  • 20
1
vote
1 answer

How to export selected functions, selected procedures, selected views and selected tables only from oracle database using command line?

Suppose I want to export Views named V1, V2 Functions named f1, f2 Procedures named p1, p2 Tables named T1, T2 username : system password : manager sid / schema : DB3 So I fire command on CMD as follow, (1) expdp system/manager@DB3…
अक्षय परूळेकर
  • 314
  • 4
  • 16
1
vote
0 answers

Oracle IMPDP not importing rows

I am trying to import one table from a full DB export but the table I want will not import the rows. If I try another table then the rows import fine! Using Oracle 11.2.0.4 in Windows 2008 R2 The export was successful : Job "BKUP_USER"."EXPFULL"…
Robert K
  • 98
  • 1
  • 11
1 2
3
…
11 12