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
1
vote
2 answers

Failure while exporting table from Oracle XE Database

We have XE running on a docker container. When trying to export a table I got the below error expdp test/test@XE tables=UserProfile directory=/tmp dumpfile=profile.dmp logfile=logger ORA-39006: internal error ORA-39213: Metadata processing is not…
pocman
  • 325
  • 4
  • 14
1
vote
0 answers

How to mask the table data using that column name while exporting the table [using EXPDP]

I want to mask a table data while exporting using expdp. Table "TEST_MASK" has two columns: 'address'(varchar(100)) & 'balance'(varchar(50)) Here we need to mask address column using this column name and balance column value. Test_mask table: …
Abhi
  • 55
  • 9
1
vote
1 answer

impdp one dumpfile to multiple tablespaces

In my Oracle 11.2 I have a schema MAIN with 500 tables distributed on 5 tablespaces. 100 tables in TBS1, 100 in TBS2 and so on... Default for user MAIN is TBS1. Sometimes for some reason i have to export the schema MAIN expdp \'/ as sysdba\'…
user2265417
  • 74
  • 1
  • 7
1
vote
1 answer

Ora-39000 bad dump file specification when exporting dump file using expdp

I am trying to perform a windows scheduler job which will create back up of my database daily once. So for this reason I have created batch file SYSTEM_BACKUP.bat which contains data: @echo off setlocal EnableDelayedExpansion expdp SYSTEM/SYSTEM@XE…
Andrew
  • 3,632
  • 24
  • 64
  • 113
1
vote
1 answer

How can I export Oracle schema from my local machine to Remote using expdp and impdp command

I want to take the back up of my local Oracle instance and want it to import on my remote server. I have searched the web but couldn't find any solution. The solution I got is: Export from local and import into only local. Export from Remote and…
Mukesh Singh
  • 303
  • 2
  • 5
  • 17
1
vote
1 answer

Altering row data while using Oracle expdp utility

I'm a developer -not a DBA or DB expert - but as part of my job I should be able to export data to get it imported into another DB. While exporting I need to be able to alter row data that is going into dump files. Is that possible? Let's say I have…
Pokuri
  • 3,072
  • 8
  • 31
  • 55
0
votes
1 answer

expdp table with specific columns

I have a table in my database with 100 columns. I am only interested to create a dump using expdp with only 3 specific columns from it. Is it possible to do this directly from the expdp command?
pOrinG
  • 896
  • 3
  • 13
  • 27
0
votes
0 answers

Full database export failing in Oracle 12C

Command executed: expdp SHELAZ/SHELAZ full=Y directory=dpump_dir dumpfile=SHELAZ20221215.dmp logfile=logfile.log Facing below error: Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning,…
Shelton Tapiwanashe Ndindana
  • 1
0
votes
0 answers

ORA-00904 whlie executing impdp

I'm trying to import ORIG schema into TEST schema. ORIG schema was exported with filename exp_orig.dmp. Following are the command I executed and its referencing parfile(imp_testdb.par). command : impdp TEST/123@TESTDB…
unciahan
  • 1
  • 1
0
votes
0 answers

export schema from Autonomous DB with apex workload

I have an Autonomous DB on OCI with apex workload, so no wallet and no chance to connect with SQL developer nor any other client. expdp command in cloud shell needs should be the only way but again the apex worload doesn't allow wallet…
Soren Stirner
  • 11
  • 1
0
votes
0 answers

Oracle19c use exp command export full database error EXP-00061

I use the command exp parfile=/opt/p.par to export the database, the content of the p.par file is userid=system/sys123 file=/opt/exp.dat log=/opt/exp.log compress=no direct=y full=y rows=no This is the error Log About to export the entire database…
kldd
  • 39
  • 5
0
votes
1 answer

EXPDP failing because of sys package error

In one of the Oracle 19c databases any expdp or impdp command is failing with the below error ORA-31626: job does not exist ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at…
Vishal5364
  • 293
  • 1
  • 4
  • 21
0
votes
0 answers

oracle data pump export dump file to UAT environment

I am trying to learn data pump export and import of tables in oracle. I am asked to export from the device to UAT/sit environment. I have a doubt. I have been practicing this on my laptop with 2 pluggable databases. As it's on the same device, the…
ramya
  • 33
  • 1
  • 8
0
votes
2 answers

expdp/impdp connection string

I am currently trying to copy a schema with the name in lowercase. So in order to connect via sqlplus I simply do: sqlplus \"schema_name\"/schema_pass@localhost/DBRAZRAB That works well. Of course naively I tried the same approach for expdp/impdp,…
PavelPraulov
  • 589
  • 6
  • 18
0
votes
1 answer

Am I impdp dump file in Oracle database 11g R2, right?

I have a dump file without log file,I have no idea what the expdp schema users are,so editing a parfile like below: directory=my directory remap_schema=rx:tbs table_exist_action=replace My problem is that the user "rx" is not…
jack zh
  • 1
1 2
3
4 5 6 7