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
2 answers

ORA-29283: invalid file operation: nonexistent file or path [29434] trying to restore database or read text files

I have just installed Oracle 21c on a Windows 11 Professional machine. I am trying to restore a database with this command: impdp system/*****@//localhost:1521/orclpdb dumpfile=mydumpfile.dpdmp directory=expdp_dir When I execute the IMPDP command,…
Ken M
  • 23
  • 3
0
votes
2 answers

Oracle: using impdp from a full DB expdp

I’ve got a full Dump of an Database (all schema, system etc...) Now I want to import just one schema of this file, is this even possible? As far I got this command: impdp sysadm/sysadm@sysadm schemas=sysadm directory=dp_dir dumpfile=export.dmp…
domiSchenk
  • 880
  • 4
  • 23
  • 41
0
votes
0 answers

ORA-00904 whlie executing impdp

I'm trying to import ORIG schema into TEST schema. ORIG schema was exported with filename exp_orig.dmp. Following are the command I executed and its referencing parfile(imp_testdb.par). command : impdp TEST/123@TESTDB…
unciahan
  • 1
  • 1
0
votes
1 answer

how to import data into oracle ,when primary key conflict ,overwrite old data with new data

how to import data into oracle ,when primary key conflict ,overwrite old data with new data ,just use cmd line ,using imp or impdp ,why oracle doesn't supply the overwrite option try in command line
stone2317
  • 1
0
votes
0 answers

ORA-39126 Worker unexpected fatal error in KUPW$WORKER.PUT_DDL [FUNCTION:"ABC"."GETSYSDATE"]

we have a development server and we are importing database from the production server using datapump impdp, but it terminates with ORA-39126 Worker unexpected fatal error in KUPW$WORKER.PUT_DDL [FUNCTION:"ABC"."GETSYSDATE"]. we had a power failure…
biramani thangjam
  • 11
  • 1
0
votes
0 answers

Oracle 19.5 giving ORA-39358 for 19.0 dump

I am importing 19.0 dump (exported on Oracle 19.0c) on Oracle 19.5c oracle. But it give strange message as below, Import: Release 19.0.0.0.0 - Production on Wed Mar 23 05:46:48 2022 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its…
DMR
  • 1
0
votes
0 answers

oracle data pump export dump file to UAT environment

I am trying to learn data pump export and import of tables in oracle. I am asked to export from the device to UAT/sit environment. I have a doubt. I have been practicing this on my laptop with 2 pluggable databases. As it's on the same device, the…
ramya
  • 33
  • 1
  • 8
0
votes
2 answers

expdp/impdp connection string

I am currently trying to copy a schema with the name in lowercase. So in order to connect via sqlplus I simply do: sqlplus \"schema_name\"/schema_pass@localhost/DBRAZRAB That works well. Of course naively I tried the same approach for expdp/impdp,…
PavelPraulov
  • 589
  • 6
  • 18
0
votes
1 answer

Oracle IMPDP: Import all the tables and delete the tables that I have in the tablespace

I have the following import impdp userprod/oracleu_23 FULL=Y REMAP_TABLESPACE=TB_SYS_DAT:TB_DATA REMAP_SCHEMA:ADMIN:USERPROD directory=DIR_DMP_FILES dumpfile=DWH_PLAN_PARAM_20220104.dmp logfile=DWH_PLAN_PARAM_20220104.log I have a doubt If I…
Jeniffer Lorena Guillen Castro
  • 75
  • 2
  • 8
0
votes
1 answer

Am I impdp dump file in Oracle database 11g R2, right?

I have a dump file without log file,I have no idea what the expdp schema users are,so editing a parfile like below: directory=my directory remap_schema=rx:tbs table_exist_action=replace My problem is that the user "rx" is not…
jack zh
  • 1
0
votes
0 answers

ORA-04023: Object SYS.AQ$_REG_INFO could not be validated or authorized

I am using Oracle 19c version 19.3.0.0.0, trying to import a dumpfile from a 12c, using impdp. The 19c is divided in three pluggable databases, but only one is showing the given error. impdp ****/***@db1 schemas=SCHEMANAME dumpfile=DUMPNAME.dmp …
redVelvet
  • 1
  • 1
0
votes
0 answers

Migrate the database from the windows server to the Linux server from different versions 11g to 19c

We need to migrate the database from the windows server to the Linux server from different versions 11g to 19c. Source: Oracle Product Version:11.2.0.4 Operating System: Microsoft Windows x64 2012 R2 Database Size:1.5TB Target: Oracle Product…
ram kumar
  • 7
  • 3
0
votes
1 answer

import data into Oracle 18xe using IMPDP failed

I have created a new oracle DB 18xe on a docker. I am trying to import a dump file using the following command impdp **/**@xepdb1 directory=DATA_PUMP_DIR dumpfile=file.dmp remap_schema='source:dest' logfile=imp.log CONTENT=DATA_ONLY I am getting…
OceanWavez
  • 291
  • 1
  • 2
  • 10
0
votes
1 answer

Using impdp from a dump file without an active Oracle instance

I have an Oracle dump file (created via expdp), and I want to export it into a DDL file. I understood that for that I need to use the impdp tool with the sqlfile as a parameter. However, it seems to require a running Orcale instance (although I…
itairos
  • 1
0
votes
1 answer

Importing dump using impdp throws ORA-39083 and ORA-04079 (invalid trigger specification)

Importing a dp dump file that contains a trigger gives error ORA-39083 and ORA-04079. I'm using Oracle XE 11g 64 bit on Windows 10. I export a schema that contains a trigger with status 'VALID'. When I import the dump file again in the same database…
J. Ouwehand
  • 115
  • 2
  • 10
1 2 3
…
11 12