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

Getting the following error ORA-27038 when importing dump file

I imported dump file using data pump to another DB_B on the same server. The server already contains the same DB_A which has similar contents as the dump file. I did the following command (below) with DB_A and it works perfectly but when I used it…
dimas
  • 2,487
  • 6
  • 40
  • 66
0
votes
1 answer

how to import with full database with split export files

My client uses the following script to take backup with export datapump: expdp system/******** logfile=exp_pdco1mob00_full_12232013.txt directory=ABC …
user3155148
  • 1
  • 1
  • 1
  • 1
0
votes
0 answers

Importing only one user data from a Dump file

I am using oracle 11gr1 SingleByte Database, I am trying to import a Dump file. but strangely the dump file contains multiple user objects(i.e, Import(IMPDP) is not done properly). example: . . "TEST"."AUDVALUES" 174.5 MB 2136286…
Maddy
  • 3,726
  • 9
  • 41
  • 55
0
votes
1 answer

How do I append data with Oracle's impdp?

Does impdp always truncate the table before it loads the data even if I don't recreate the meta data? If it does, is there an option to tell it to append the data instead?
Aaron Digulla
  • 321,842
  • 108
  • 597
  • 820
0
votes
2 answers

How to rollback impdp in oracle11g

I have the task to import oracle database (big data) with the command impdp. I have to migrate big data which take a long time. Is there a way to rollback the database when during the import job has been interrupted? Thanks
user2082666
  • 1
  • 2
0
votes
2 answers

Oracle remap_Tablespace for Datalob/Data/Index

I'm facing a new problem about importing data on Oracle. I've got a dump file of around 40GB, and I'm trying to import this to my Oracle Database 10g Release 10.2.0.4.0. On our system we have 3 tablespaces (Datalob/Data and Index), one of our…
domiSchenk
  • 880
  • 4
  • 23
  • 41
0
votes
1 answer

How to import 2 copies of almost the same database in Oracle at the same time?

I have a properly functioning up to date 10g database locally that I don't want to mess with. I need to do some queries on a customer's database locally which is a couple versions behind from our current software. I had exported their full db…
user83598
  • 161
  • 1
  • 3
  • 10
0
votes
1 answer

Oracle data pump import into existing table

i need an efficient way to copy data from one database to another. Both are based on Oracle 11g. Step: (Re)create new tables Step: Install pl sql packages Step: export tables tab_old1 and tab_old2 from database 1 with expdp Step: import into…
user1328819
  • 113
  • 2
  • 3
  • 7
0
votes
1 answer

Import of data in Oracle using impdp fails because of missing dependencies

I need to export a subset of an Oracle table and import it in another Oracle instance. The export using expdp works pretty well but when I try to import the data in the other instance using impdp tool it fails because there are dependencies (foreign…
user1225775
  • 253
  • 5
  • 14
-1
votes
1 answer

Import of .dmp file not happening

I have created a Directory D44 CREATE DIRECTORY D44 AS 'C:/Users/Siddharth/Oracle_dump_files'; and given it access through another user using this command grant read,write on directory D44 to FINANCE9; But now when I am trying to import .dmp files…
Siddharth Kumar
  • 1
-1
votes
1 answer

Oracle Datapump impdp Inappropriate ioctl for device

i had an error while exporting my schema and then import it into a new database. My Exporting System is an Oracle Linux 7 with 19c Database and the importing system is Oracle Linux 8 with 21c XE. When i import the schema with impdp i receive the…
Ivan1986
  • 19
  • 4
-1
votes
2 answers

Oracle expdp and impdp command?

I want to know the Oracle expdp and impdp command for sys user and scott/tiger user for entire database or a particular table.I will be grateful if you share me the script of expdp and impdp.I also want the script of recovery of a entire database…
tanayals
  • 37
  • 1
  • 3
-1
votes
1 answer

Oracle data pump import/export parameters

When I was going through a data pump import parameter file, I came across the below line, EXCLUDE=TABLE/TABLE I would like to know the purpose of this line or the effect to import process if the line is removed.
mmafrar
  • 281
  • 4
  • 9
-1
votes
2 answers

Lot of time spent with following waits 'SQL*Net message from client' and 'wait for unread message on broadcast channel'

My application that wraps around Oracle Data pump's executables IMPDP and EXPDP takes random amounts of time for the same work. On further investigation, I see it waiting for again random amounts of time with the event 'wait for unread message on…
Shravan
  • 223
  • 1
  • 5
  • 12
-3
votes
1 answer

impdp (19c) taking way too long ! [processing-DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX]

How to improve and speed up the import further? impdp status : at 30 % from almost 2 days :: Operation: IMPORT Mode: SCHEMA State: EXECUTING Bytes Processed: 563,545,353,768 Percent Done: 30 Current Parallelism: 6 Job Error Count: 0 Job…
Dothertechie
  • 27
  • 6
1 2 3
…
11
12