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

Migrate the database from the windows server to the Linux server from different versions 11g to 19c

We need to migrate the database from the windows server to the Linux server from different versions 11g to 19c. Source: Oracle Product Version:11.2.0.4 Operating System: Microsoft Windows x64 2012 R2 Database Size:1.5TB Target: Oracle Product…
ram kumar
  • 7
  • 3
0
votes
1 answer

Data Pump export using cloud shell

I am trying to export schema using data pump on Oracle Cloud Autonomous database. I am using cloud shell to export schema. When I tried to do the final step: expdp admin/password@DB_HIGH schemas=SCHEMA_NAME directory=data_pump_dir dumpfile=exp%U.dmp…
Goku
  • 441
  • 5
  • 20
0
votes
1 answer

how to import a dmp file with profiles from a CDB db to a PDB DB instance using impdp in Oracle 12c?

I have a dmp file from a CDB(don't know exactly) in another server from where, I was given a dmp file which was exported using expdp(possibly). I want to import it into a PDB instance on an Oracle 12c server which I have. I extracted the sql file…
Jithu Paul
  • 154
  • 2
  • 15
0
votes
1 answer

Export and Import using Data Pumps in Oracle 19c

I have a table in which I want to add a new char type column Before adding the column took the export , then dropped the table and then recreated the table and then did the import using the same dump file. When I checked the value of new added…
Niket Agrawal
  • 1
0
votes
0 answers

oracle deletion of data for some period of time in script

need to add in the start of script to delete export dump 3 days old and then start export backup, script should not execute without deleting old backups, if it fails to delete old backup , script should terminate and send us alert. # $Header:…
bp_db
  • 21
  • 5
0
votes
1 answer

export table with expdp oracle

I am trying to export a table from my oracle database with SID=DB034 with username=b034. I am using this command: expdp b034/aDmin123456789@DBB034 tables=B034.BIL_CUSTOMER_GROUP, DEPT directory=exp_test dumpfile=dump_test.dmp…
Masoud
  • 108
  • 8
0
votes
1 answer

expdp command gives error on Ubuntu server for Oracle Database

I've been trying to export oracle datadump with "expdp" utility in Oracle 18c. I've set the environment variables under ~/.bashrc as following export ORACLE_HOME=/home/ubuntu/oracle-database-xe-18c-1.0/opt/oracle/product/18c/dbhomeXE export…
Tanay Suthar
  • 453
  • 3
  • 8
  • 19
0
votes
1 answer

Seperate log path and dump path in expdp

I have to run multiple exports in one of the Oracle 12c databases for which I am using PAR files. Now I want to put the dump file and the log file in separate paths while using expdp. Please guide me on how to achieve this
Vishal5364
  • 293
  • 1
  • 4
  • 21
0
votes
1 answer

How do I export a schema with all data to my local instance on my PC (Oracle XE)

The Server is Oracle 11g 11.2.0.4.0 The local instance of my Oracle is "Oracle Database 18c Express Edition Release 18.0.0.0.0" I want to export the schema called "AlphaTest" and all it's associated triggers, tables, views, packages, etc and import…
software is fun
  • 7,286
  • 18
  • 71
  • 129
0
votes
1 answer

AWS RDS datapump directory to be used

I know nothing much about aws. Could you help to resolve the issue. I need to take a dump of my Database in AWS Oracle RDS, so trying a command which is shown below expdp ***/****@WINDMIG5 schemas=agTransform directory=/rdsdbdata/datapump…
XSL Query
  • 11
  • 4
0
votes
0 answers

Oracle - Error During Impdp Of Full DB 11g Database

I have 2 databases. I want to expdp operation on sample schema for first database and I want to impdp operation on second database. I finished as well expdp operation but I can't do clear impdp. I used this command for export: expdp…
newbieoracler
  • 1
  • 2
0
votes
1 answer

how to put name difference for daily backup

I created a backup cmd file with this code EXPDP system/system EXCLUDE=statistics DIRECTORY=bkp_dir DUMPFILE=FULLDB.DMP LOGFILE=FULLDB.log FULL=Y it works good, but, when I run the backup again, it finds that the file exists and terminate the…
adel sameer
  • 43
  • 1
  • 9
0
votes
0 answers

impdp table with blobs from expdp dump

Can someone here help me with impdp syntax to import a table with a different name in the same schema or a different schema (trying to make a copy of an existing table with BLOBS). I was trying something similar to the below, but it didn't…
Dothertechie
  • 27
  • 6
0
votes
1 answer

export table using expdp issue

I am trying to export a table of size 2GB, Oracle 12c (12.1.0.2.0/Non CDB) I tried using the below commands, 1) expdp system/pwd tables=schema.tablename directory=DATA_PUMP_DIR dumpfile=expdp_xxxxx.dmp logfile=expdp_xxxxx.log 2) expdp…
Dothertechie
  • 27
  • 6
0
votes
1 answer

Is it possible to import a schma to Oracle 18c Express Edition from an Oracle 11g Standard Edition Dump file?

I have a dump file (one schema, size is less than 1GB) which is created (Using EXPDP) from Oracle 11g standard edition (VERSION Parameter not used). Is it possible to load this dump file to an Oracle Database 18c Express Edition using IMPDP?
vishnudas
  • 53
  • 1
  • 10
1 2 3
4
5 6 7