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

Slow import of data using impdp for index organized tables in oracle..is there a way around?

I have a table of around 50G which i want to move into another environment. the method we chose is to export the data from a source IOT table using expdp create a temp IOT table without secondary index use impdp with the below command. The issue I…
BVAD
  • 75
  • 2
  • 6
1
vote
1 answer

Can I continue exporting data despite the snapshot too old error?

I am exporting a schema from Oracle production database to create a new, test database. Unfortunately, I received the error ORA-01555: snapshot too old Despite the error, export still in progress .dmp file is growing. I don't care about the…
Karol
  • 127
  • 1
  • 10
1
vote
2 answers

How could I make the exp/expdp Oracle CLI works with a cronjob in Linux?

I have the following cronjob defined in my /etc/crontab Linux file: * * * * * oracle cd "/home/oracle" && exp "user"/"password"@"TNS" owner="user" file="user".dmp log="user".log; For purposes of exemplification, the asterisk symbol * is being used…
ilwl
  • 35
  • 1
  • 6
1
vote
1 answer

Oracle XE 18c impdp dump from 19c

I have a dump file that is created using expdp from Oracle 19c (exported with version parameter 18). Is it even possible to import the dumpfile to an Oracle 18c XE database? The structure and everything else from the 19c database is unknown to me. I…
Marc Jansen
  • 11
  • 5
1
vote
2 answers

ORACLE DB exp with FULL=y option cannot export all user tables but expdp can

I am trying to use the exp tool to backup the whole DB. The command is "exp userid=system/manager@test inctype=complete buffer=65535 file=/home/oracle/backup/exp_full.dmp log=/home/oracle/backup/exp_full.log full=y". But from the exp log, it can…
Gucheng
  • 11
  • 2
1
vote
2 answers

Oracle expdp bash sh pass password with at

According to: https://oracle-base.com/articles/10g/oracle-data-pump-10g#expdp passing authorization data we have pattern: [user]/[password]@[sid] How to pass password with at (@) ? Such this is breaking a pattern and not work: expdp…
user1785960
  • 565
  • 5
  • 17
1
vote
1 answer

Datapump REMAP_DATA using another column

I need to mask first and last name. Our requirement is to use the first name only. How can I access the FIRST_NM field when masking the LAST_NM? LAST_NM=substr(FIRST_NM,1,4)||'LAST' select T.EE_FIRST_NM, T.EE_LAST_NM from…
Dan R
  • 13
  • 4
1
vote
1 answer

can't export using expdp, can't open log and more

I had been asked to create a table: '/u03/oracle/table/prac_tab.dbf' and import it to '/u04/backup' Now, my problem begins when i do the following code: [oracle@haranda ~]$ expdp paris dumpfile=parisbk1.dmp logfile=parisbk1.log full=y…
Henry Aranda
  • 43
  • 7
1
vote
1 answer

Downloading oracle RDS table data to a local database

I have an Amazon Oracle RDS database. I would like to export the RDS table and import it to my local database. The kicker is that it includes a NCLOB column. The local system is Win10 running Cygwin. I run expdp to capture the data: $ expdp…
wdtj
  • 4,554
  • 3
  • 17
  • 20
1
vote
1 answer

How to export selected functions, selected procedures, selected views and selected tables only from oracle database using command line?

Suppose I want to export Views named V1, V2 Functions named f1, f2 Procedures named p1, p2 Tables named T1, T2 username : system password : manager sid / schema : DB3 So I fire command on CMD as follow, (1) expdp system/manager@DB3…
अक्षय परूळेकर
  • 314
  • 4
  • 16
1
vote
1 answer

How to export oracle database version 12.1.0.2.0 with expdp Release 12.2.0.1.0

I am running following command to dump my database ./expdp username/password@//host:port/database directory=/home/ubuntu/oracle/instantclient_12_2 dumpfile=dumpfilename.dmp content=METADATA_ONLY and getting following error Export: Release…
Bhaskar Dabhi
  • 841
  • 1
  • 11
  • 28
1
vote
1 answer

expdp where clause errors

I'm attempting to do an export dump based on a query clause. The table holds 2.37bil rows and i need to dump a subset of those. Here is my…
phemor
  • 299
  • 6
  • 17
1
vote
1 answer

ORA-00959: tablespace 'USERS' does not exist. But I have it in select results

I'm trying to import a DB dump {Oracle XE 11g (11.2.0.2.0)}, created by using the EXPDP command. Following is the command that I used to import. impdp vnp/vnp directory=MY_DATA_PUMP_DIR dumpfile=EXPDP_DUMP_26_01_2018.DMP remap_schema=VNP_ADMIN:VNP…
Asela
  • 117
  • 1
  • 3
  • 12
1
vote
1 answer

How to do a full oracle database export or import yet exclude one tablespace

I'm working on creating a scheduled task to do a weekly refresh of an Oracle 11g database from production to test. I want to do a full export / import with the exception of one tablespace named PERFSTAT which we use in production with stats pack,…
John-Rock Bilodeau
  • 377
  • 5
  • 15
1
vote
3 answers

export large number of tables using expdp

My Environment has more than 4000 tables. I want to export only 2000 tables. I tried using par file using Include clause. But the export is failing. Details are mentioned below Tool: EXPDP | Oracle Database version:11g R2 | Number of tables to be…
Sujit Kumar
  • 31
  • 1
  • 2
  • 5
1
2
3 4 5 6 7