Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [expdp]

The tag has no usage guidance.

1
vote
1answer
67 views

Why doesn't Oracle expdp create the dump file?

I'm trying to export a schema from an Oracle 10.2.0.5.0 database. For some reason, when I launch the expdp command, it finishes almost immediately and it only creates the log file, no dump file at all....
0
votes
1answer
26 views

Using JOINS in QUERY clause in EXPDP

I have a par file that is using JOINS in QUERY clause. But it is not working. directory=expdp DUMPFILE=Test_SIT_Query_1table_%U.dmp encryption_password=oracle parallel=8 logfile=TEST_SIT_Query_table....
0
votes
0answers
89 views

Oracle impdp only imports one schema from a dump into which expdp exported many schemas

I have the following problem and doubt in Oracle. I am trying to import with impdp a dump from my database into which I exported several schemes. The problem comes when I try to import into the same ...
1
vote
1answer
207 views

expdp Hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM in oracle 12c

Expdp Hangs at Below Stage for long time even in structure backup also . Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM Processing object type ...
1
vote
1answer
27 views

Oracle Data Pump Export

If I want to export all the tables in a schema, can I just specify the schema parameter in the parfile or do I also need to list out all the tables individually in the tables parameters? I tried ...
1
vote
2answers
92 views

Move expdp part file before job end

I have an Oracle 11gr2 database running on Enterprise Linux 6.6 server. I use the following command to split the expdp dump file to 10G size chunks: expdp userid=/ DIRECTORY=dmpdir dumpfile=dump%u....
0
votes
1answer
74 views

Impdp 12c takes table original size

I want to import one of my schema "vvs1" to r&d database with content=metdata_only. expdp works perfect but when i am going to import on r&d server it takes tables original size. for example:-...
1
vote
1answer
2k views

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 ...
1
vote
1answer
1k views

ORA-39001: ORA-39000: ORA-31640: ORA-27041: and Linux-x86_64 Error: 13: Permission denied [closed]

I used this command to export data: expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW Now importing this to other server as: [root@linux gsw]# impdp gsw/password ...
1
vote
1answer
397 views

Can expdp be piped directly into impdp, without intermediate files?

We often need to copy fairly large databases from one server to another. The current method uses expdp on the source, and then impdp on the destination. This gets pretty horrible because: It takes up ...
0
votes
1answer
107 views

Oracle Transportable Database export ORA-39340: unsupported object, INDEX

I want to get data dump from PDB(Transportable Database). DB version 12.2.0.1.0. Enterprise Edition. Before I get export I applied oracle 27162931 and 27162975 opatch. Then I altered tablespaces ...
1
vote
1answer
11k views

How to replace and overwrite all existing objects in Oracle with impdp for full database import?

I want to replace all the existing objects in my database, not just tables, into my current database. I ran expdp with the parameter full=yes as the system user, who I granted ...
0
votes
1answer
926 views

Using Oracle Directories names as same of path

We, at our company, have been using a small hack on Oracle Directories names since some time ago. Before Oracle Directories we have to explicitly set the directory on pfile, by the utl_file_dir ...
1
vote
1answer
314 views

Pass .csv file as parameter file for expdp Oracle 11.2.0.4.0

Can we use .csv file as parameter file for expdp ? Ex: expdp scott/xxx@dev parameter=table_full.csv Thanks
1
vote
1answer
217 views

Need help on expdp and impdp concept [closed]

I have a multiple databases i.e (database1,database2) and i need to export a table from database1 to database2 . Here are the commands i tried expdp hr/oracle@oracle tables=emp directory = ora ...
0
votes
1answer
657 views

Is there a way to Oracle expdp not inherit char type nls semantics on DDL?

expdp, by default, generated internal DDL to create table observing current NLS_LENGTH_SEMANTICS of each column. If a column as BYTE (the default and most used) NLS_LENGTH_SEMANTICS, the internal DDL ...
-1
votes
2answers
3k views

ORA-01555:Snapshot too old error during execution of expdp command [duplicate]

After performing expdp command in production database (Oracle 11g - linux): expdp abc/123 DIRECTORY=data_pump DUMPFILE=SA10_%u.dmp LOGFILE=SA10.log TABLES="abc"."/1FE/019" PARALLEL=4 CONTENT=...
1
vote
1answer
790 views

IMPDP from Oracle 10g TO 11g

I'm not able to import the full database from oracle 10g to 11g using impdp FULL=Y. It seems that the file path is differing so what shall I do? The impdp command is looking for oracle 10g path while ...
1
vote
2answers
632 views

Oracle file permissions expdp vs dbms_datapump

We have written our own export function using calls to dbms_datapump. In some systems the export fails due to insufficient file permissions on the chosen directory. However, using expdp to perform ...
0
votes
2answers
2k views

Oracle full expdp/impdp but skip data in some tables

I'm trying to export a schema and then import it, but there are some huge tables that I must skip all the data from (that is, I need the tables and all stuff related to them, just not the rows). So I ...
1
vote
1answer
167 views

Error in database export

I'm using Oracle 11g databse. For logical backup, we are exporting database on daily basis using below command and dump size is almost 12GB. , but now I'm facing an issue with my expdp. expdp 'sys/...
0
votes
1answer
415 views

ROWID and expdp

Can anyone please tell me if ROWID is also exported in expdp process ans stored in dumpfile. Can I use the following while importing? QUERY=table_name:\"WHERE rowid = (select min(rowid) from ...
1
vote
1answer
4k views

Datapump export taking too much time to complete

I've scheduled to take a backup of my oracle11g database, daily at 11pm via Windows Task Scheduler. At this time, I'm not letting my database to go down. Also, my database is in noarchivelog mode. ...
0
votes
3answers
785 views

Issue in DB export

I've scheduled to export my database at every midnight via Windows Task Scheduler. This was properly exported for so long. But, recently in some days, export is not happening as required. The logs are ...
2
votes
1answer
1k views

Sequence number shows a lower value after dump file import

I'm using Oracle 11g database in which I have more than 12 schema's consisting of many tables. I've created sequences for primary keys to these tables. I've also created synonyms to refer my ...
1
vote
1answer
1k views

oracle expdp similar method to export datas for SQL Server

On our oracle databases, we regularly run database export through expdp/impdp utility (wrapped for readability): $ expdp user/[password] SCHEMAS=<nom_schema> DIRECTORY=expDatapump ...
1
vote
1answer
10k views

Oracle 12c: installing expdp and impdp on Linux

The default Oracle installation for Linux didn't come with the expdp and impdp command line tools. I have trouble finding them on Oracle's website. How could I install them?
0
votes
1answer
668 views

EXPDP snapshot too old live monitoring

The likely errors that raises "snapshot too old"s during datapump export are the well documented all over the internet such as : undo_retention parameter being too short redo logs groups are too ...
0
votes
0answers
211 views

How do you import an exported dump file into a pre-built oracle 11g virtual machine?

I have successfully downloaded and installed this pre-built virtual machine with Oracle 11g. I am able to access the scott/tiger database and view table contents successfully. I am currently trying ...
0
votes
2answers
4k views

How to export own objects using expdp without special privileges?

As per this post on Oracle forums expdp can be used to export your own schema without any special privileges: It all depends on what you want that user to be able to export/import. If all that ...
1
vote
1answer
781 views

Oracle migration unable to create indexes

I want to move the contents of a database instance to another using the expdp and impdp utilities. The source instance is version 12.1.0.1.0 and the destination is 11.2.0.1.0 so I modified the expdp ...
1
vote
2answers
923 views

Are expdp/impdp commands appropriate for daily schema sync?

I've done following comands: expdp system/password@localdb ^ schemas=SCH directory=dumps_dir dumpfile=SCH_%date%.dmp logfile=expdpSCH_%date%.log It runs great, without errors. But when I use command:...
0
votes
2answers
17k views

Export pump all schemas except Sytem related schemas

I have around 111 schemas in one database instance and have to export all the schemas except the system related schemas to a new instance. Is there any way as to exclude system related schemas while ...
0
votes
0answers
198 views

How to know imdp size?

I have a dump file using expdp with compression (oracle version >= 11g). Before running impdp I want to check if there is enough space on the machine but it seems as there is no parameter in the impdp ...
1
vote
1answer
837 views

impdp syntax for schema that is not available on other database

My intention is to import the data of schema 'SCOTT'. I have exported it from db1 using expdp scott/tiger schemas=scott dumpfile=scottexp.dmp ...... Now When I try to import the same in database db2 ...
1
vote
2answers
17k views

Oracle Full Client / Database Client package locations

I need to install multiple versions of the Oracle client on an app server for an automation project. The platform I'm looking for in specific is Linux, 64 bit. Oracle's network of websites are a maze ...
0
votes
0answers
1k views

ORA-26097: unsupported conversion for column SYS_NC0000500006$ (from type 58 to type 23)

I have an Oracle Enterprise Edition as a source and taken the dump using the oracle data pump(expdp) and the dump is imported using (impdp) to an Express Edition of Oracle. The import was working ...
1
vote
1answer
2k views

Oracle expdp et impdp : order of schemas?

When I try to export and then import many schemas from one Oracle DB to another one, I get errors because grants and synonyms cannot be recreated in the target DB; the reason is probably that the ...
1
vote
1answer
5k views

Expdp error UDE-22303

I am experiencing the following error, when I am trying to make an export to the database using expdmp utility: UDE-22303: operation generated ORACLE error 22303 OCI-22303: type "SYS"."KU$...
0
votes
1answer
2k views

Export Data Pump all data from few schemas except one table structure only?

we use to make a copy of schemas from one database and move it to another for testing using this par file ... DIRECTORY=EXPORT DUMPFILE=QQS_PROD.DMP LOGFILE=QQS_PROD.LOG SCHEMAS=QQSDATA_PROD,...
-1
votes
1answer
6k views

Importing only one user data from a Dump file

I am using oracle 11gr1 SingleByte Database, I am trying to import a Dump file. but strangely the dump file contains multiple user objects(i.e, Import(IMPDP) is not done properly). example: . . "...
0
votes
3answers
25k views

Exporting schema data (tables, permisions) into another schema on same database

I want to take data from one schema schema1 and put it into schema2 this should be quite easy to do but i have searched through the oracle documentation and can't find a way to do it.
2
votes
1answer
1k views

Consistent Database Export of Oracle Database

I'm quite confused and I need some clarification! I do full export of database with Export Pump (for replication/duplication). What I usually do is: SQL>SHUTDOWN IMMEDIATE SQL>STARTUP ...
27
votes
2answers
158k views

How to transfer data using expdp and impdp commands?

I'm an Oracle noob, and my intention is to transfer all data and metadata from one schema to another schema within an Oracle database. I'm planning to use datapump's expdp and impdp commands. I have ...