Questions tagged [impdp]

For questions about the Oracle Data Pump Import (invoked with the impdp command). Use together with the [oracle] tag.

Filter by
Sorted by
Tagged with
0
votes
0answers
21 views

Recursively list dependencies / references of a stored procedure

I'm trying to import a subset of our production dump with impdp for our local development database running on Oracle XE. To find out what other objects I have to import for a particular stored ...
2
votes
2answers
39 views

Import Tables without Constraints from Schema Export

I am trying to do an import using data pump, but I am struggling to come up with the right options. The export was taken as a schema export. I am trying to import just the tables, with no other ...
0
votes
0answers
7 views

oracle db 19.3: impdp: use more than one cpu core on linux

I'm running impdp 19.0.0.0.0 on openSuSE 15.1 vm and processing object types takes far too long. On htop I see that only one CPU core (of totally 8) is used. Doing research for about an hour didn't ...
0
votes
1answer
70 views

What does Oracle impdp do when a name clashes with a materialized view or synonym?

I have a production Oracle database, and I want to export tables, data, views, materialized views, synonyms, etc, to import into a development Oracle database. Actually, this is part of my job, and we ...
1
vote
1answer
33 views

normal Linux user for oracle database dumps

is it possible to allow normal linux user " neither root nor oracle " to be able to execute expdp and impdp and to have access to dpdump directory with rw access on oracle database 12c ? i ...
0
votes
0answers
19 views

Import with Network link fails with ORA-01400

Oracle 12.1.0.2.0 Setup a simple Import using Network Link, into same database Using REMAP_TABLE and REMAP_SCHEMA options. Full import.prm file is: NETWORK_LINK=mylink NOLOGFILE=YES CONTENT=...
0
votes
2answers
73 views

Unable to import DMP file that is made in 11g2 to Oracle 18c

My OS=CENTOS 7 Oracle=18c XE I am trying to import a DMP file that is exported from XE 11g2 and now trying to import it in 18c XE. Here are the errors: [root@linux gsw]# impdp user/pass ...
-2
votes
1answer
167 views

bad dump specification [closed]

when trying to import a database to a local machine I get this error: [oracle@9250f1edf0c7 /]$ impdp user/pass dumpfile=EXPDPDAT-OWNER.dmp directory=dpump_dir1 content=ALL REMAP_TABLESPACE=INDEX:DATA ...
0
votes
1answer
70 views

Can I use impdp FULL=Y for an Oracle database charset conversion?

I need create a copy of an Oracle 12.2 instance (Oracle Restart) running on an Linux VM. The new instance needs a charset conversion from WE8ISO8859P1 to UTF8 I started by creating a clone of the VM ...
2
votes
1answer
193 views

Nulling a BLOB column in Oracle 11 impdp

I need to import a 50 GB dump file containing three schemas. Over 90% of the file is taken up by a single BLOB column. How could I import the schemas, including the table containing the blobs, but ...
2
votes
1answer
155 views

Oracle - impdp - import a partition

I truncated a partition, and would like to import it from backup. How can I import a partition from the dump file? Export log: . . exported "XY_PROD"."XY_LOG_PLSQL" 69.16 MB 320459 ...
0
votes
1answer
127 views

Oracle 12c. Is it possible to export a TDE encrypted table using expdp / impdp to a database without TDE / wallet enabled?

I have an Oracle 12c database where I have encrypted certain columns of several tables, I want to import or load these tables into another database which does not have TDE enabled, as would be ...
0
votes
0answers
50 views

Unable to generate DDL statements using impdp 12c

I am trying to generate DDL statements from the data in a dump file, by importing the dump file using impdp. This is my export log: ;;; Export: Release 12.2.0.1.0 - Production on Thu Dec 12 01:56:...
0
votes
0answers
84 views

Multiple errors import Oracle 12c DB impdb

I am a custom developer and I need to restore an Oracle DB and receiving multiple errors during the import. Very new to oracle, thanks in advance System has been granted read/write on dump directory ...
0
votes
0answers
104 views

Import Schema dump into multiple schemas

I have a production schema and for upgrade they have decided to use 3 schema instead of one. For deploying this into production I have to take dump of schema A and import into 3 different schema with ...
0
votes
0answers
110 views

ORA-01466: unable to read data - table definition has changed

What happen when is done a import from a export with this erro? I have a table that every day is altered the structure during the consistent export (flashback_time=systimestamp) and I always receive ...
1
vote
1answer
46 views

Does the target database need to have the same structure of the source database before to use IMPDP?

When I do a import from another database have I need the same estruture of the source database in the target database? For example, if my source database use ASM and my target database no, what have I ...
0
votes
1answer
71 views

Why expdp does not include identified by statement?

I have the following error when I do a impdp (from a pdb in a 12c to 11g. I also used the parameter version=11.2.0) IMPDP LOG: ORA-01938: IDENTIFIED BY must be specified for CREATE USER Failing sql ...
1
vote
1answer
2k views

ORA-39097: Data Pump job encountered unexpected error -942

Would somebody know what is that error? This is during the impdp command and there is nothing imported. The full error is: Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - ...
0
votes
0answers
231 views

How can I import the fga_log$ table with impdp Oracle 12 R1

I am trying to import with impdp a save made as follows: expdp '"sys/mmm as sysdba"' full=y COMPRESSION=ALL DIRECTORY=LOGICS_EXPORTS COMPRESSION_ALGORITHM=BASIC LOGTIME=ALL CONTENT=ALL DUMPFILE=FULL-...
2
votes
1answer
2k views

Migrated DB from 12c to 19c with IMPDP failed

I have migrated a DB from 12c to 19c with IMPDP and EXPDP. While importing I have seen some errors. Below is an extract of the errors. Errors During Import Processing object type SCHEMA_EXPORT/TABLE/...
1
vote
1answer
3k views

How to Import an Oracle dump version 5.1 into 12c?

I have .dmp files exported as version 5.1 and I need to import them on an Oracle 12c. I have no access to the original database to re-export setting the VERSION parameter. This is the error I get: ...
1
vote
1answer
3k views

ORA-39002, ORA-39168 on IMPDP, Object path GRANT was not found

I'm trying to impdp a schema with just one table on it. The impdp parfile looks like this: LOGFILE=scott_impdp.log DUMPFILE=scott.dmp SCHEMAS=scott REMAP_SCHEMA=scott:scott2 REMAP_TABLESPACE=scott:...
0
votes
0answers
704 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
140 views

Oracle impdb on windows generates a subdirectory

I am importing to a windows oracle, a dump file produced on Linux. But oracle generates a subfolder in the dpdump directory /76E0F91BE49D480CB2633847BD640FC5\ and causes an "ORA-31640: unable to open ...
0
votes
1answer
3k views

Database Hangs while impdp “DATABASE_EXPORT/STATISTICS/MARKER” at this stage

I am using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production i am facing issue while impdp on other server. it hangs at the last line message below. it takes min. over 2-3 ...
0
votes
1answer
322 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:-...
0
votes
2answers
839 views

Oracle db impdp command syntax error

I'm trying to run impdp system/password dumpfile=FILE.dmp fromuser=USER1 touser=USER1 directory=$DIRECTORY on oracle server but keep getting following error: LRM-00118: syntax error at '=' at the ...
0
votes
0answers
662 views

NLS_ENV is not a valid job attribute Impdp oracle

I'm facing this error while importing database using data pump from 12c to 11g while importing job scheduler ORA-39083: Object type PROCOBJ failed to create with error: ORA-27469: NLS_ENV is not a ...
1
vote
1answer
4k 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 ...
2
votes
1answer
2k views

Avoid already existing objects when importing into Oracle

I need help with impdp. I have taken a backup with: expdp system/pw@orcl full=y directory=abc dumpfile=full.dmp Now I need to import the dump into another instance, which has recently been created. ...
1
vote
2answers
2k views

DBMS_DATAPUMP error: The current API cannot be executed because of inconsistencies between the API and the current definition of the job

I'm trying to do an impdp on a Amazon RDS Oracle instance using DBMS_DATAPUMP. I'm following the steps described in the Amazon RDS guide (Importing Data into Oracle on Amazon RDS). I've already ...
1
vote
1answer
936 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 ...
6
votes
3answers
28k 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 ...
1
vote
1answer
294 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 ...
1
vote
1answer
1k 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
1answer
1k views

Oracle data pump import parallel configuration

I am trying to track down a cause for a difference in oracle impdp processing, and I am not finding anything, so I am wondering if anyone here can explain the cause of the differences. At times I ...
1
vote
1answer
4k views

restore database using impdp full back

I have new server and i installed oracle 10g same like production. and I have databump full backup using sys user. I need to restore on the new server. I used the following command while database is ...
6
votes
2answers
17k views

impdp stuck on index import

impdp import is stuck on: Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX How can you debug this?
0
votes
2answers
5k 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 ...
0
votes
1answer
723 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 ...
0
votes
0answers
1k views

Issue COMMIT in between impdp process

I am using Oracle DBMS_DATAPUMP API to import a dumpfile containing some table data. Is it possible to stop the job and issue COMMIT; in the same session to maybe cleanup UNDO tablespace and then ...
2
votes
1answer
3k 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 ...
2
votes
1answer
2k views

Oracle expdp puts INDEXES to LOGGING mode

I've created a table in schema LARRY create global temporary table TT1 (N number); create index TT_IX1 on TT1 (N); then export it, and try to import in schema LARRY2: expdp LARRY/LARRY directory=...
3
votes
1answer
5k views

Oracle Data Pump, pause a job

I currently have a impdp job running for a fairly large schema (2TB) and ran into an error. The source database has one column that is larger then the destination database. This is causing ORA-02374 ...
2
votes
1answer
18k 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
2answers
242 views

Import datadump in schema mode [closed]

why am I encountering this error when executing impdp command? My command looks like this: impdp directory=dp_dir dumpfile=testdb.dmp logfile=testdb.log Error message: ORA-39002: invalid ...
0
votes
1answer
5k views

ORA-00959: Tablespace '$name' does not exist when using impdp

I'm new at Oracle databases. I'm executing an impdp command and encountered this error: ORA-00959: tablespace '$name' does not exist. Is the only thing I can do is to create the $name tablespace?
-1
votes
1answer
903 views

HELP - impdp from expdp - do i need to get the .dmp file to the RDS DATA_PUMP_DIR

I've been beating my head against a stubborn wall trying to get a expdp of an oracle schema (on premises db) loaded to my new Oracle RDS instance. I saw this comment from you and it sounds exactly ...
-2
votes
1answer
90 views

importing 50gb+ dmp using imdp

Attempting to import 50GB+ dumpfile using impdp. Hitting the 11GB datafile limit. Never used oracle before. I created bigfile tablespace with autoextend on. Perhaps I should use different approach?