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

Error in master table while importing a single table using Oracle DBMS_DATAPUMP

This issue has been found in Oracle 12.2 only. Oracle 12.1 seems OK. I provide everything to reproduce, but you also need to create an Oracle directory. I named it DUMP_DIRECTORY. We have 2 SQL procedures: EXPORT_TABLE: Export a…
rt15
  • 87
  • 1
  • 1
  • 7
2
votes
1 answer

Error Importing a .dmp file in AWS RDS Oracle DB

I have followed the AWS Importing Data into RDS guide. I have copied the .dmp file from Source Oracle Instance on another machine to the DATA_DUMP_DIR on RDS Instance. Now I am trying to import it using the code below: DECLARE hdnl…
Ajinkya Bapat
  • 619
  • 1
  • 10
  • 26
2
votes
1 answer

How to exclude certain tables from Oracle datapump export

I have a large number of user schemas in my Oracle database. I wish to export the table data for these schemas but exclude any tables that are named with the second character an underscore. For example I wish to export tables TPI_SUMMARY, DFXRRT and…
sasquartch
  • 41
  • 1
  • 1
  • 2
2
votes
1 answer

SQLPlus - Data Pump (expdp and impdp)

some time ago, I installed Oracle SQLPlus without full Oracle database package. Now I need expdp and impdp utility. Is it possible to copy important files from a full Oracle installation and pasting them into SQLPlus directory? Or maybe is there any…
KamilK
  • 319
  • 1
  • 6
  • 16
2
votes
1 answer

Datapump import is unable to open the log file

I'm trying to import the Oracle BISAMPLE.dmp schema and I've got this error ( unable to open the log file )
soha mahmoud
  • 129
  • 1
  • 2
  • 7
2
votes
0 answers

Magmi Datapump API - Invalid argument supplied for foreach()

I am trying to upload products to my Magento store using the Magmi Datapump plugin. I am currently using the sample code found in: integration > samples > sample.php but it won't add any of my files. My error log shows the following message for…
Scott Bowers
  • 175
  • 3
  • 13
2
votes
1 answer

ORA-00942: table or view does not exist error using impdp

I've been provided with a Oracle database dump which I'm attempting to import using the following: impdp myuser/myuser DUMPFILE=/u01/app/oracle/oradata/dumpfile.dmp FULL=y LOGFILE=/u01/app/oracle/oradata/dumplog.log The output is Import: Release…
Loftx
  • 1,760
  • 4
  • 29
  • 50
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
2
votes
1 answer

ORA-31655 when using VERSION=10.2 with expdp

i'm trying to export a table with Oracle Datapump, running on a Oracle 12C Instance. The schema has a table called KAT. When i do the export with: expdp USER/PASS directory=exp dumpfile=dump.dmp logfile=kat.log TABLES=KAT everything works as…
etchesou
  • 23
  • 1
  • 3
2
votes
1 answer

is it possible to recover the Oracle Data Pump master table?

I'm trying to import a few files with a published Oracle Data Pump perl script: dumpinfo.pl After successfully importing several dump files from the same export process, another file failed with: # impdp system/****** DIRECTORY=RESTORE_DIR…
gcardozo
  • 21
  • 1
  • 1
  • 2
2
votes
1 answer

Dbms_datadump fails with ORA-39117 for a table with user defined type

I have a table which has column of user defined type, I tried to move the table to a different schema, It worked fine using command line mode, however when I tries to use DBMS_DATAPUMP, it fails with ORA-39117 error, below are the filters I had…
Raghavendra Acharya n
  • 93
  • 2
  • 7
2
votes
1 answer

Oracle Data Pump import to a sql file error :ORA-31655 no data or metadata objects

I'm using Data Pump to export/import data, one requirement is to import data to a sql file. The OS is window. I made the follow export : expdp system/password directory=dpump_dir dumpfile=tablesdump.dmp content=DATA_ONLY tables=user.tablename and…
Francisco Quiñones
  • 91
  • 1
  • 1
  • 7
2
votes
0 answers

Data Conversion from Oracle to MySQL

I am working on Data Transfer Utility which transfers data from Oracle to MySQL. While moving data from Oracle to MySQL, the engine selected for MySQL table is MyISAM which speedily inserts data. If I change Engine type to InnoDB it takes much time…
user1760986
  • 69
  • 1
  • 2
  • 8
2
votes
0 answers

Basic Authenticated HTTP Connection To SSAS Is Very Slow

I've configured my SSAS connection to use HTTP and everything works fine. The problem is that the connection is very slow when I'm using just Basic Authentication and passing the username and password as part of the ConnectionString. If I change…
Antti Simonen
  • 964
  • 1
  • 14
  • 25
2
votes
3 answers

Excluding a particular table partition during data pump export

The exclude parameter can be used to filter out schema objects during export in Oracle Data Pump. EXCLUDE=object_type[:name_clause] [, ...] Is table partition a valid object_type? In other words, is it posible to exclude selected table partitions…
Raihan
  • 10,095
  • 5
  • 27
  • 45
1 2
3
…
13 14