Questions tagged [impdp]
For questions about the Oracle Data Pump Import (invoked with the impdp command). Use together with the [oracle] tag, and include the appropriate version tag, such as [oracle-12c]. If the question applies to both the impdp and expdp commands, do not use this tag; use [datapump] tag instead.
90
questions
0
votes
0
answers
38
views
with oracle impdp can you drop the objects that does not exist in the dump file but are existing in the database?
For exemple if i have a bunch of objects in the database that don't exist in the dump file, with the impdp can i drop these objects and in the end i only have the objects that are in the dump file ...
0
votes
1
answer
54
views
Interpretation of impdp/expdp character set warnings
impdp and expdp report encoding warnings in the form of:
export done in A character set and B character set
import done in C set and C character set
Why do both warnings name two character sets? What ...
- 103
1
vote
0
answers
628
views
impdp: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
I'm trying to import a large database, and after a while I get:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
I know this has been asked before, but I can't find a clear ...
- 111
0
votes
1
answer
738
views
How can i Restore Oracle 12c database Schema from a full EXPDP dump on a Test Server providing a new scheam name?
I have a production database whose full dump is 500Gig and and I cannot do a full restore on a test server because of space issues. However I need to restore a certain schema in from that dump into ...
- 19
0
votes
1
answer
480
views
Data Pump Job error caused by time zone
I'm running a impdp command for a dmp file, but when i read the log file, it show a error like this:
ORA-39097: Data Pump job encountered unexpected error -30094
ORA-39065: unexpected master process ...
- 25
3
votes
1
answer
3k
views
ORA-39014 import in Oracle 19c from DMP file of Oracle12c
I have been testing out expdp/impdp of databases from 12c to 19c( newly created database) but one db have game me this error:
nohup impdp system/****@CKLPROD CONTENT=METADATA_ONLY PARALLEL=4 DIRECTORY=...
- 43
0
votes
0
answers
409
views
Oracle XE 11.2.0 data pump expdb works on but impdb doesn't on Windows 10
New to Oracle DB administration here. I have a fresh localhost installation of Oracle XE 11.2.0 (x64 installation from here) on my computer using Windows 10 64-bit.
I am able to connect to the DB ...
0
votes
1
answer
233
views
Exclude Supplemental Logs from Import
I am trying to import tables from a production environment, to a test environment. The production environment has supplemental logs on a number of tables for golden gate replication. The ...
- 676
0
votes
1
answer
595
views
Same user cannot 'see' view on remote oracle database athough dblink is valid
I am running an impdp job that I have extracted the DDL from to determine why the job hangs. It consistently stops on the first object created using a dblink. I am running the impdp job as system as ...
0
votes
1
answer
183
views
IMPDP Job Failing with ORA-54002
I am trying to import a dump file from an 11g database into a 19c database instance. I am running the job as SYSTEM as recommended by Oracle. The job starts but quickly devolves into failing SQL ...
0
votes
1
answer
529
views
Get tablespace name from dump file
I have an Oracle dump file which I need to import but do not know what is its tablespace name. How can I get it from the dump file? I know that it is possible to get many information using impdp ...
- 103
1
vote
0
answers
350
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 ...
- 121
2
votes
2
answers
6k
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 ...
- 676
0
votes
1
answer
918
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 ...
- 101
1
vote
1
answer
356
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 ...
- 11
0
votes
2
answers
988
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
1
answer
1k
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
1
answer
798
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 ...
- 195
2
votes
1
answer
669
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 ...
- 233
2
votes
1
answer
3k
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 ...
- 155
0
votes
1
answer
621
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 ...
- 137
0
votes
0
answers
166
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:...
- 111
0
votes
0
answers
262
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
0
answers
302
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 ...
- 592
1
vote
1
answer
137
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 ...
- 592
0
votes
1
answer
195
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 ...
- 592
1
vote
1
answer
5k
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 - ...
- 11
0
votes
0
answers
562
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-...
- 137
2
votes
2
answers
12k
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/...
- 21
3
votes
1
answer
8k
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:
...
- 153
1
vote
1
answer
7k
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:...
- 11
1
vote
1
answer
509
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 ...
- 11
0
votes
1
answer
6k
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 ...
- 71
0
votes
1
answer
608
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:-...
- 71
0
votes
2
answers
2k
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 ...
- 1
0
votes
0
answers
1k
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 ...
- 71
1
vote
1
answer
7k
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 ...
- 13
2
votes
1
answer
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. ...
- 71
2
votes
2
answers
3k
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 ...
- 337
1
vote
1
answer
1k
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 ...
- 136
8
votes
3
answers
53k
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 ...
- 81
1
vote
1
answer
350
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 ...
- 133
1
vote
1
answer
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 ...
- 13
1
vote
1
answer
2k
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 ...
- 676
1
vote
1
answer
6k
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 ...
- 19
8
votes
2
answers
25k
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?
- 183
0
votes
2
answers
11k
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 ...
- 225
0
votes
1
answer
1k
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 ...
3
votes
2
answers
5k
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 ...
- 152
2
votes
1
answer
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=...
- 155