Stack Overflow
Stack Overflow

Questions tagged [impdp]

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.

166 questions
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

impdp doesn't import table data when using exclude parameter

I want to import a DB dump using below command, which will import all the data, but excluding the index and disabling the constraints impdp FERROVIAL/F3RR0V1AL@FERROVIAL PARFILE=params.par with the params file containing this…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
1
vote
1 answer

Value for EXCLUDE is badly formed Importing Oracle Database 12c Enterprise Edition Release 12.1.0.1.0

I want to import a Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production using the command : impdp SOLVIA/SOLVIA900@IMMBO DIRECTORY=DB_EXP DUMPFILE=week_exp_immbo.dmp LOGFILE=week_exp_immbo.log REUSE_DATAFILES=YES…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
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
1 answer

Impdp with remap failing on POST_TABLE_ACTION still using old schema

I'm trying to import an oracle dump while remapping schema and tablespace: impdp usr/pass \ EXCLUDE=table_statistics \ DIRECTORY=EXPDP \ REMAP_SCHEMA=ORG_USR:NEW_USR \ REMAP_TABLESPACE=ORG_TS:NEW_TS \ DUMPFILE=FILE.dmp \ …
Lukas Isselbächer
  • 863
  • 7
  • 13
1
vote
1 answer

impdp one dumpfile to multiple tablespaces

In my Oracle 11.2 I have a schema MAIN with 500 tables distributed on 5 tablespaces. 100 tables in TBS1, 100 in TBS2 and so on... Default for user MAIN is TBS1. Sometimes for some reason i have to export the schema MAIN expdp \'/ as sysdba\'…
user2265417
  • 74
  • 1
  • 7
1
vote
2 answers

Error while importing an Oracle 9 dump in Oracle 11g

I need to import an Oracle9i Release 9.2.0.6.0 dump in an Oracle 11g. Using the import command I have a ton of erros like this: IMP-00017: following statement failed with ORACLE error 6550: "BEGIN …
Andreea Madalina
  • 65
  • 6
1
vote
1 answer

How can I export Oracle schema from my local machine to Remote using expdp and impdp command

I want to take the back up of my local Oracle instance and want it to import on my remote server. I have searched the web but couldn't find any solution. The solution I got is: Export from local and import into only local. Export from Remote and…
Mukesh Singh
  • 303
  • 2
  • 5
  • 17
1
vote
1 answer

impdp with PARALLEL not working

I would like to load Oracle dump files in parallel. I have 23 cores on my machine. All the dump files were created using expdp. To do so, I ran this command: impdp $RMS_SCHEMA/amadeus@$TWO_TASK directory=RMS_DUMP_DIR2…
Lucas
  • 1,833
  • 1
  • 18
  • 19
1
vote
0 answers

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

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: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at…
Nidheesh
  • 4,390
  • 29
  • 87
  • 150
1
vote
1 answer

How can I import function based indexes using impdp?

I have a number of tables that use function based indexes (indices if you prefer). These indexes use functions within packages that I have defined. When importing the schema of the user it would appear that the tables get imported first, then the…
Paul Stearns
  • 856
  • 9
  • 30
1
vote
1 answer

Importing dump file in Oracle using impdp

I am facing troubles while using impdp in Oracle 11g. I am reading the documentation but still am missing some point. I created a test database, along side with the oracle_home of orcl database. I created the directory as /home/oracle from orcl…
GuilhermeMesquitaX
  • 177
  • 1
  • 1
  • 8
1
vote
1 answer

Import dump file to another Database with default schemas

I have the following command to import a dump file to another Database (DB_B) with different schema. Oracle's Data Pump import impdp SYSTEM/PASSWORD DUMPFILE=dpump_dir1:expfull.dmp FULL=y LOGFILE=dpump_dir2:full_imp.log expfull.dmp from DB_A…
dimas
  • 2,487
  • 6
  • 40
  • 66
1
vote
1 answer

Turn Off Deferred Segment Creation for Oracle IMPDP

I have a program that is calling Oracle's impdp utility to import a schema. I encounter the following errors: ORA-14223: Deferred segment creation is not supported for this table The tables that are failing have a column of VARRAY. How could I…
timmy
  • 1,752
  • 6
  • 23
  • 35
1
vote
1 answer

Oracle: Remotely import using Impdp with DB link

I'm trying to import a schema using data pump. Here's my problem: I can only access the impdp utility on the source DB server, but it's version 11.1, and the target DB version is 11.2, so if I run the import, I got an error: UDI-00018: Data Pump…
Cal
  • 747
  • 1
  • 13
  • 30
1 2 3
…
11 12