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
1
vote
0answers
64 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/...
0
votes
0answers
12 views

Importing dump file after dropping database

I was trying to import a dump file and for some reason i decided to drop database; so oracle got shut down and when I tried to start it, it said no pfile or spfile were there so I created them using ...
1
vote
1answer
211 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
394 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
25 views

impdp not importing rows

impdp copies tables in the schema but data is not loaded. Same impdp command on another database works with the same dump but does not work in another database. command used impdp username/password@...
0
votes
0answers
274 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 ...
0
votes
1answer
1k 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
115 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
419 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
338 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 ...
1
vote
1answer
2k 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
227 views

Error while importing full oracle database

I was trying to do full database import. I created tablespaces manually from sql developer DBA option. Then did import but am facing this errror. Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/****...
2
votes
1answer
952 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
1k 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
549 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 ...
2
votes
1answer
15k 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
243 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
944 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
719 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 ...
0
votes
1answer
2k 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 ...
5
votes
2answers
12k 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
3k 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
496 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
2k 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
4k 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 ...
1
vote
1answer
12k 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
171 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
3k 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
838 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
84 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?
0
votes
1answer
52 views

Creating oracle Database instace

We need to create a oracle database instance similar to customer environment. What are all the parameters needs to be considered other than similar version of software. Like Character set, Multibyte ...
2
votes
1answer
1k views

How to debug an hanging impdp importation

I am currently trying to import a database dump in Oracle XE 11gR2 On windows 7. I have the following command. impdp 'APPLICATION/APPLICATION@XE' dumpfile=APPLICATION.dmp REMAP_TABLESPACE=...
0
votes
1answer
3k views

Export from Oracle 10g and import to Oracle 12c unable to create users

I have and old install of Oracle 10g with a lot of users and tablespaces in it, for development purposes. Now, I need to migrate these users, tablespaces and everything else, to an Oracle 12c ...
0
votes
1answer
7k views

How do I kill a non-running impdp job?

I am trying to run an import operation into an Oracle 11G R2 database from a .dmp file using SQL Developer 4.1's Data Pump Import Wizard. I set everything up with IMMEDIATE start, but then the job ...
1
vote
1answer
824 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 ...
2
votes
2answers
3k views

Can I do an impdp with a file on my local computer

I was given a dump file which is currently on my local computer. I want to import this to our Oracle 11G DB which is hosted on a server. Do I need to move this file to the server to do the impdp or ...
-1
votes
3answers
7k views

impdp schema name not found

I have Oracle Database 11.2.0.4. I want to import a dump file to it with impdp. The Dump file is for the Popualtion schema. The schema's name is case sensitive. How can I import this file to database? ...
1
vote
2answers
999 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
0answers
214 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 ...
0
votes
0answers
264 views

Oracle 10.0 package shows INVALID status in reference on oracle 11g on import with IMPDP

I have imported dump of oracle 10 version with tables, procedures and packages to oracle 11g version. While am not facing any issues with tables and procedures, certain body of packages compiles with ...
1
vote
1answer
874 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 ...
2
votes
0answers
1k views

Fast restore of dropped partitions

I want to test the restore of erroneously dropped partitions of a subpartitioned table. This restore would consist of three steps: restore the database (or at least the necessary tablespaces) to the ...
3
votes
1answer
3k views

Oracle IMPDP job ORA-30036 unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

I'm using IMPDP with the "network_link" for perform export/import in a single-pass. It runs fine until I get this error. ORA-39171: Job is experiencing a resumable wait. ORA-30036: unable to ...
0
votes
1answer
2k views

ORA-39244:Event to disable dropping null bit image header during relational select [closed]

I was trying to import a dump file using IMPDP command and has end up with the following errors: ORA-31626: job does not exist ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user user1 ORA-06512:...
0
votes
1answer
2k views

Increase in temporary tablespace while import

When i am importing some tables in my database, the temporary tablespace is getting full. This never happened earlier for other tables. Please help me know why this is happening and any solution for ...
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 ...
0
votes
1answer
1k views

RAC, data guard, physical stand by and impdp

We're setting up a RAC 2 nodes data guard 11g environment, with a remote physical standby (2 nodes also) We receive the client's data he exports with expdp. We have imported his dump in the primary ...
1
vote
0answers
2k views

Impdp over DB_LINK failing with ORA-31631

I am getting below error message while trying to execute impdp between our SIT and UAT environments: ORA-31631: privileges are required ORA-39149: cannot link privileged user to non-privileged user ...