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

LRM-00116: syntax error at 'DIRECTORY' following '='

Hi I'm creating a script to refresh oracle schema. While trying to backup the schema I kept getting the error below. I have searched everywhere and no one seems to be having this same exact error. Any…
user6027133
  • 23
  • 1
  • 1
  • 9
0
votes
1 answer

gives many errors when using expdp command

expdp is giving the following errors. C:\db>expdp SYSTEM/xxx@orcl directory=dump_dir dumpfile=anew.dmp log=export.log schemas=anew Export: Release 11.2.0.4.0 - Production on Qua Fev 17 17:09:00 2016 Copyright (c) 1982, 2011, Oracle and/or its…
Bolha
  • 253
  • 3
  • 8
0
votes
2 answers

Import Database IMPDP - Different Versions

We are having oracle installed in 2 different servers. Server 1: Oracle Version Details Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production PL/SQL Release 11.2.0.2.0 - Production "CORE 11.2.0.2.0 Production" TNS for 32-bit…
RobinHood
  • 2,367
  • 11
  • 46
  • 73
0
votes
1 answer

Set Specific Database for EXPDP - Two Oracle Databases

I have installed 2 oracle databases (i.e) 2 different instances in a server. From Username, Password, SID, Listener everything is different. Like Mentioned Below. Instance 1: Username : TEST Password : TEST123 Port : 1111 SID : ForTest Instance…
RobinHood
  • 2,367
  • 11
  • 46
  • 73
0
votes
1 answer

Export Oracle dump to remote disk

So I have this task: export full database. There is a remote machine, on which Oracle 11g server is running. It is low on disk space, so exporting using expdp won't work. Also, I do not have Oracle server on my local computer, so exporting using…
Dan
  • 39
  • 11
0
votes
1 answer

Java Process hangs during stdInput reading

I got some problem trying to launch a process that executes an EXPDP command to make the backup of a Oracle DB. This is the method that launches the process, the problem is when I try to read from stInput and stdError. The process hangs forever, and…
lateralus
  • 1,020
  • 1
  • 12
  • 35
0
votes
1 answer

expdp dump file is big

I am trying to make dump of Oracle database using the expdp tool. I added the exclude=statistics option to the command line to make the resulting dmp file smaller, but the file is still very big even with this setting. Is there some other setting…
Martin Staufcik
  • 8,295
  • 4
  • 44
  • 63
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
-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 2 3 4 5 6
7