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

Oracle DB: Convert timestamp (CET/CEST) columns to UTC while doing Oracle export/import

My issue is that my oracle db has timestamp(6) column (without any timestamp information) but the timestamps are stored in CET/CEST (Europe/Berlin). We need to correct the timestamps to UTC (because we already have issues when time switches from…
max
  • 1,134
  • 10
  • 16
0
votes
0 answers

EXPDP Running too slow

we have a database with size 16GB.We are running daily backup using EXPDP,but few days ago this EXPDP taking too long to complete(more than 6 hours). my question is 1) does TABLE LOCKS affect performance of EXPDP(i have checked for table locking and…
vishnudas
  • 53
  • 1
  • 10
0
votes
3 answers

How to use query clause in EXPDP

I am exporting data of a table through EXPDP by using the below command nohup expdp \"/ as sysdba\" directory=DATA_PUMP_DIR dumpfile=EXP.dmp logfile=EXP.log version=11.2.0.4 TABLES=CRM.CATEGORIES QUERY='"where bank_id='43'"' Getting the below error…
Vishal5364
  • 293
  • 1
  • 4
  • 21
0
votes
1 answer

How to export oracle undetermined schemas using expdp

I want to export Oracle database, but not full and not determined schemas; for example schemas that their names like 'IAS%' Or schema name like 'YS%' I have written this command: Expdp admin/admin@orcl schemas like 'IAS%' file=my_data.dmp…
Saddam Meshaal
  • 532
  • 3
  • 13
  • 30
0
votes
1 answer

Count the no. of tables exported using expdp in Oracle database

I have a bash script in which I will be running the expdp command. Now, I would like to count the no. of tables exported using the expdp command.I need this, because sometimes the expdp can be halted in the middle and I would like to know, how many…
JavaTechnical
  • 8,846
  • 8
  • 61
  • 97
0
votes
1 answer

expdp issue ORA-39001: invalid argument value

Originally, the script was like: C:\Windows\system32>expdp anna/12356@inst2 PARFILE=E:\expdp\db001\_db001.par Export: Release 11.2.0.3.0 - Production on Mon Sep 3 22:59:30 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights…
Lydia_5678
  • 1
  • 1
  • 1
0
votes
1 answer

Import and replace package & procedure in oracle

I wanted to import packages and procedures to DB x from another DB y. I used expdp command with include=procedure, package in DB y to export the package and procedure. In DB x some packages and procedure are already there, so those packages which…
aruns
  • 1
  • 1
  • 1
0
votes
1 answer

Expdp command from java

I have to take oracle table export and import dump file from java using expdp command. Form cmd it is working as expected. But when the I'm doing the same from java there are two issues: if expdp command have include keyword then it shows the…
amitabh pandey
  • 65
  • 1
  • 11
0
votes
2 answers

Oracle 12C: ORA-00406: COMPATIBLE parameter needs to be 12.2.0.0.0

We have a 2 current Oracle 10G(10.2.0.1) production databases, and we are planning to migrate to a new database server with Oracle 12C. Since data is for each database is only around 5GB, the best way to create a new instance and use data pump to…
Drew
  • 710
  • 1
  • 15
  • 34
0
votes
1 answer

powershell scripting for expdp

I am using the expdp command for backup and redirect the output into a text file. While this is in process, the console is blank. I would want to write a powershell script to display a status message as "In progress" until expdp command execution is…
stackingknowledge
  • 1
  • 1
  • 4
0
votes
1 answer

Oracle Data Pump Transfer Between Databases

I have a specific need for data pump and I am having a hard time searching for a solution. Currently, I have a exp/imp program that exports tables (selectively based on queries) from one database, and imports that same data into another database.…
Gary G
  • 41
  • 2
0
votes
2 answers

How can I export/import subset data from/to Oracle Database?

I was wondering what would be the approach to get rid of a lot of records from an Oracle database in order to create a lighter database for developer's laptops. We aim to reduce the exports from different production environments NOT excluding…
Max
  • 2,508
  • 3
  • 26
  • 44
0
votes
1 answer

Oracle Datapump API

I am rewriting an application, that imports and exports oracle database. I was using imp.exe and exp.exe executed as Processes from code. Now I'm trying to use impdp and expdp instead of them. I studied some samples at https://docs.oracle.com/,…
Eva Leigh
  • 51
  • 1
  • 9
0
votes
0 answers

How to restore database with impdp

I have Oracle 12c database and I execute expdp command to create dump file. Later I want to be able to restore database using this dump file, on the same location as where the dump was created from. I don't want to stop database, which is required…
user1809566
  • 175
  • 1
  • 4
  • 15
0
votes
1 answer

Has anyone tried oracle export : EXPDP on the remote machine?

I am trying to export a dump file and log file on a remote machine using oracle expdp. However i am getting the following error : Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning,…
Vaibhav Mhala
  • 33
  • 1
  • 8
1 2 3 4
5
6 7