Stack Overflow
Stack Overflow

Questions tagged [datapump]

A server based bulk import and export facility in Oracle

Data Pump Export and Import replace Import and Export. It can be used to import or export tables, schemas or entire databases in a dump file.

Questions tagged should also be tagged .

Further reading:

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

import a oracle dumpfile

I have an oracle dump file which I assume has been created using the exp command and not the expdp The dump file is about 4 GB and I would like to import it into my Oracle 11.2 database. The dump file which was created has the tablespace as "spaceA"…
Barry
  • 1,585
  • 3
  • 22
  • 35
0
votes
1 answer

how do i do an incremental import into a 9i database

I need to carry out the append feature of the impdp utility while importing a 11g database dump into a 9i database. I also need to be able to do it the other way round for importing into a 11g database from a 9i database using the same append…
user2539163
  • 21
  • 1
0
votes
2 answers

Oracle datapump exported tables

My situation is quite strange, and i don't have any ideea on how to handle it. Scenario: In variable v_tables_param I have the following string (the names of the tables that iwant to export) 'IN(''REPORT_PERIOD'',''OBJECT_AVAILABILITY'')'. when i…
Teshte
  • 624
  • 1
  • 7
  • 26
0
votes
3 answers

Oracle RAC : Unable to import .DMP files in DB using IMP or IMPDP commands

I am trying to import .dmp files into my oracle 11g DB. I set below ENV varables, and then I am trying to run imp and impdp commands, but I am getting below errors. Can anyone help me here? What are the possible errors in importing dmp files to RAC…
user1632316
  • 91
  • 1
  • 3
  • 5
0
votes
1 answer

Datapump conversion from big endian to little endian

I have Oracle DataPump with tables in a single dump file. They were exported from the Big Endian system (Solaris), now I need to import them to Little Endian System (Windows). If I try to import without the conversion I have unreadable cyrillyc…
Rookie Boy
  • 39
  • 1
  • 3
0
votes
1 answer

Oracle Data Pump (expdp and impdp)

Currently i'm using expdp and impdp to export and import my schema in my pc. i have wrote two scripts to export and import and run that scripts using batch file when i need. Now i'm going to host my application on a Remote server. i need to backup…
Bishan
  • 15,211
  • 52
  • 164
  • 258
0
votes
1 answer

oracle export and import datapump

I have a quick question on oracle datapump. I have a small oracle database 11gR2 which contains different schemas (more than 8).I want to move this database to a new server and i am trying to use impdp/expdp method. I did a full export of the…
cableload
  • 4,215
  • 5
  • 36
  • 62
0
votes
1 answer

PLSQL function compilation errors when using Oracle data pump

I have two PLSQL functions in an Oracle database. Function A uses function B. Therefore to compile function A successfully function B must already be there. When I use data pump to import the functions it is importing function A before function B,…
user1578653
  • 4,888
  • 16
  • 46
  • 74
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

Oracle Data Pump Import imports LONG with spaces after evfery character

I'm importing an 11g oracle schema into a 10g database using data pump import/export. The problem is that on one of my LONG columns, when importing the data data pump seems to put a space after every character, so the data goes from looking like…
user1578653
  • 4,888
  • 16
  • 46
  • 74
0
votes
1 answer

Excluding statistic using Data Pump API

How to exclude all statistics while exporting data using Oracle Data Pump API (DBMS_DATAPUMP package)?
Raihan
  • 10,095
  • 5
  • 27
  • 45
0
votes
2 answers

Unable to allocate x bytes of shared memory

When I'm trying to backup my oracle database, I got below error. UDE-04031: operation generated ORACLE error 4031 ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","SELECT j ob_id FROM v$datapum...","SQLA","tmp") ORA-06512: at…
Bishan
  • 15,211
  • 52
  • 164
  • 258
0
votes
1 answer

Datapump library

I'm developing a java program and with it, I want to be able to import and export oracle datapump. Do you know any library that i could use which will enable me to do so? Another option is to do it with the console, but I'm not very keen on doing…
mokko211
  • 597
  • 2
  • 9
  • 25
-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 2 3
…
13
14