Stack Overflow
Stack Overflow

Questions tagged [expdp]

For issues relating to the expdp Oracle data dump export.

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.

99 questions
6
votes
3 answers

How to export users in Oracle with its roles and system privileges using expdp?

I am trying to export a schema/user in Oracle with its roles and system privileges. I don't want to export any data or any table. I have tried to export users using the following command. expdp system/system@gisdblocal include=user DIRECTORY =…
Ayaz49
  • 325
  • 2
  • 4
  • 18
3
votes
1 answer

Oracle full EXPORT with exclude and NOT using par file

I need to do a full export of a 12.2 database. Recently we placed 2 tables in it with over 4 million records that will remain static. I'd like to eliminate them from the daily EXPDP as they have been archived offline. This EXPDP is launched via a…
coffeeANDVolts
  • 45
  • 6
2
votes
1 answer

Unable to remap_data while using datapump export

Could anyone help with my datapump export. I've tried many combinations. But, I'm always getting: ORA-39001: invalid argument value ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4932 ORA-06512: at…
amir
  • 331
  • 2
  • 9
  • 20
2
votes
0 answers

Exporting schema from oracle database is breaking views

I am exporting with expdp a schema from a database and the process finishes with no error but when I try to use impdp to import the schema, several views fail to be imported with the following message: ORA-39083: Object type VIEW failed to create…
Javier
  • 135
  • 1
  • 9
2
votes
2 answers

oracle 11g impdp returns invalid operation and object was not found

I wanted to transfer an oracle table between two users using expdp and impdp commands. First of all, I created a directory and granted proper privileges to source and destination users: SQL> CREATE OR REPLACE DIRECTORY TEST_DIR AS…
Zeinab Abbasimazar
  • 9,835
  • 23
  • 82
  • 131
2
votes
1 answer

Does expdp remove data in Oracle?

I am going to perform an upgrade on a Hadoop cluster but am wanting to backup the Ambari metastore schema first in case anything goes wrong. Oracle is used to store the data, so I looked at using expdp to make a quick backup of the schema in its…
Josh
  • 718
  • 2
  • 15
  • 38
2
votes
1 answer

Oracle Export and Import

Some Background: Somewhere around Oracle 10, which was about a decade ago (give or take), Oracle added a new method of exporting and importing databases called the Oracle Data Pump. Aside from the silly name, the functionality works mostly the same…
theMayer
  • 15,456
  • 7
  • 58
  • 90
2
votes
0 answers

Datatype changed after IMPORT of schema

please advice on EXPDP and IMPDP utilities, Oracle 12c DB administration. We exported schema TEST (DB 11.2.0.4) using EXPDB utility and imported dump file to new DB (DB 12.2.0.1.0) using IMPDP utility. After import we checked one of tables -…
Bulat Makhmutov
  • 555
  • 2
  • 8
  • 14
2
votes
0 answers

Oracle EXPDP from remote client

I am running Oracle expdp process from a remote client using the command line. I can see the process starts and there are few progress messages shown in the command prompt window. But, after some time there are no further progress messages. When I…
sandeep chennupati
  • 21
  • 1
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
2 answers

Use Oracle-Linux expdp to windows network drive

I am trying to use expdp to perform an export on some tables of my Oracle DB my code: expdp AAA/***@xxx schemas=AAA include=TABLE:\"= \'TBL001\'\" directory=DUMP_DIR dumpfile=dmpfile.dmp logfile=lgfile.txt This is what I get: ORA-39002: invalid…
Marcello Manfredini
  • 61
  • 2
  • 8
2
votes
0 answers

Single Byte to Multi Byte Conversion

We are converting a Oracle Single Byte instance into Multi-Byte. Following is the summery of steps we have following: Take an export of Single Byte schema Generate DDL file from exported Dump in step 1(Only table Definitions). Run these table…
Maddy
  • 3,726
  • 9
  • 41
  • 55
2
votes
2 answers

Oracle export using expdp gives ORA-29283: invalid file operation error

I want to export my database using expdp and I am running the below command for export: expdp SYSTEM/SYSTTEM PARFILE=export_dump.par The export_dump.par file contains the below…
Andrew
  • 3,632
  • 24
  • 64
  • 113
2
votes
1 answer

How to use QUERY in expdp to extract only the last 3 months data

In my other thread, I have asked how to extract only the last 3 months. However, I managed to extract data from the last 3 months only from one table and it extracted all data for other tables. I have several tables in my schema and the column…
Joie Tamayo
  • 501
  • 3
  • 8
  • 21
1
2 3 4 5 6 7