Oracle data pump error ORA-39082 with wrapped packages

oracle EE 10.2.0.3 is running on AIX.I created a package in which I use the datapump API to transfer a schema over the database link using datapump.Unfortunatelly I got the following error:ORA-39082: Object type ALTER_PACKAGE_SPEC:"OWNER"."PACKAGENAME" created with compilation warningsfor all wrappe ...

Oracle data pump error ORA-39065, status undefined after restart

The data pump full import job hung, continue client also hung, all of a sudden the window exited.;;; Import> status;;; Import> help;;; Import> status;;; Import> continue_clientORA-39065: unexpected master process exception in RECEIVEORA-39078: unable to dequeue message for agent MCP from ...

Oracle data pump error ORA-39082 with wrapped packages

oracle EE 10.2.0.3 is running on AIX.I created a package in which I use the datapump API to transfer a schema over the database link using datapump.Unfortunatelly I got the following error:ORA-39082: Object type ALTER_PACKAGE_SPEC:"OWNER"."PACKAGENAME" created with compilation warningsfor all wrappe ...

Oracle Data Pump Error - ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has

I am getting the following errors when I am trying to connect with datapump.My db is 10g and os is linux.Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsORA-31626: job does not existORA-04063: package body "SYS.DB ...

Oracle Data Pump: Importing partitioned objects into target DB w/o partitioning

I have the following issue when importing partitioned tables from a source DB to a target DB without the partitioning option.In this scenario, the tables and indexes on the target are already present, solely without partitions. Release is 10gR2. First try: impdp user/pw directory=dump_dir dumpfile=t ...

Oracle Data Pump -Importing one table index

Is it possible to import one table index alone(any table ex emp ) .If it can be how should the param should look like .. ...

Oracle ORA-39080: failed to create queues "" and "" for Data Pump job

Any idea?many thanks$ expdp USER/PASSWORD@DB1 schemas=USER directory=datapump dumpfile=USER.dmp logfile=USER.log   Export: Release 10.2.0.1.0 - Production on Tuesday, 30 March, 2010 17:33:14   Copyright (c) 2003, 2005, Oracle. All rights reserved.   Connected to: Oracle Database 10g R ...

Data Pump Export issue - no streams pool created and cannot automatically create one

SOLVED, see my replyI am trying to use data pump on a 10.2.0.1 database that has vlm enabled and getting the following error :Export: Release 10.2.0.1.0 - Production on Tuesday, 20 April, 2010 10:52:08Connected to: Oracle Database 10g Release 10.2.0.1.0 - ProductionORA-31626: job does not existORA-3 ...

Oracle data pump problem

I am facing the a problem during running expdp. The command is failing with the following error when I try to use expdp command:Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit ProductionWith the Partitioning and Data Mining optionsORA-31626: job does not existORA-3163 ...

Data Pump Export on Oracle 10g

I have Oracle 10g. When I try to use data pump export utility, following errors have occured:ORA-31626: job does not existORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user FNSONLDORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPV$FT_INT", line 600ORA-39080: failed to create q ...

Oracle data pump error???

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsORA-31626: job does not existORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYSTEMORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPV$ ...

Oracle data pump

I'm trying to test data pump but problem is I can't seem to make it work. I;m getting the error below:oracle@db1 dbdata2 $ expdp system/password FULL=y DIRECTORY=test_dir DUMPFILE=datadb.dmp LOGFILE=datadb.logExport: Release 10.1.0.4.0 - 64bit Production on Monday, 24 October, 2005 18:52Copyright (c ...

Oracle Data pump failed

Data pump was working fine in past. All of a suden I started getting thses errors:Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsORA-31626: job does not existORA-31637: cannot create job SYS_EXPORT_FULL_01 ...

Oracle Export data pump error

I am doing export data pump (expdp) and sometimes I got this error. This is not a regular error. Sometimes received this error while other times I don't. I cannot add more memory. Does any one can explain the cause of this ir-regular error. ThanksExport: Release 10.2.0.3.0 - 64bit Production on Mond ...

Oracle Data pump use streams pool?

I have oracle 10.2.0.3 database running on Linux x86 using Oracle Enterprise Linux 32 bits.I wanted to use a 64bits "os"/database since I have a 64 bits machine. But since Oracle does not support "hsodbc" in 64 bits yet. I am stuck using Oracle 32bits. See metalink 261726.1. Yeah that sucks. I have ...

Oracle data pump error

I am gating this error in oracle(10g) database whene I am using oracle data pump for creation a .dmp file. I have done this following stape.1> create directory dd_dp as '/irb/dev2/ssau/dpdata1';2> grant read, write on directory dd_dp to <user_namer>;3> expdp username/password DIRECTOR ...

Oracle Data Pump API - Exception

I create a procedure for to be invoked to transfer the contents of the a particlular schema to the another schema in the same dbI get the following Exception in Data Pump jobORA-31626: job does not existORA-31633: unable to create master table "ICLARCHIVE.ARCHIVE_TRIAL"ORA-06512: at "SYS.DBMS_SYS_ER ...

Oracle Data pump errors

I have newly created schema now and created external directory...i am testing the expdp but i am getting the following error:Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-3162 ...

Oracle data pump import problem

i have exported Hr schema from one macine using following code it export successfully but i tried to import this exported file in another machine it gave error. one thing more how i use package to import file as we exported by using data pump using package plz help C:\Documents and Settings\remote ...

Oracle Data Pump Export issue - no streams pool created and cannot automatically c

I am trying to use data pump on a 10.2.0.1 database that has vlm enabled and getting the following error :Export: Release 10.2.0.1.0 - Production on Tuesday, 20 April, 2010 10:52:08Connected to: Oracle Database 10g Release 10.2.0.1.0 - ProductionORA-31626: job does not existORA-31637: cannot create ...

Oracle ORA-24315 returned by data pump import

Using data pump utilities, I exported data from Oracle 11g R1 (11.1.0.7) on Windows XP 32-bit then tried importing it into Oracle 11g R1 (11.1.0.7) for Windows 2003 Server 64-bit. Following is what I got:C:\oracle\oradb11g\olap\admin>impdp system/pss REMAP_TABLESPACE=HH07_DATA: NBS_DATA DIRECTORY ...

Oracle Data Pump and importing LONG, BLOB, CLOB and RAW columns

Can someone please confirm if the issue where importing LONG, BLOB, CLOB and RAW columns via Data Pump fails has been resolved in later releases of Oracle Database Server?I believe when attempting to import a Data Pump export with tables containing these column types you get an error like:ORA-31693: ...

Oracle 10gR2 Data Pump Export to NFS mounted drive fails. Results in ORA-27054 err

Trying to use data pump to export files to an NFS mounted drive. Job never initiates because of the following error: ORA-27054: NFS file system where the file is created or resides is not mounted with correct optionsAdditional information: 6I have read the Note:338086.1 and have tried the different ...

Oracle Regular data pump backups Failed - ORA-39125

Please let me know teh root cause of this problem and solution...AS we are doing regular data pump backups for a database and suddenly it's start failing two times in a row today....Here is the Error message from log:Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPECORA-39125: Worker ...

Oracle DATA PUMP API returning ORA-31655

I am using below code to import a table(EMP) from one Database to Another using Network.set serveroutput on;DECLAREind NUMBER; -- Loop indexspos NUMBER; -- String starting positionslen NUMBER; -- String length for outputh1 NUMBER; -- Data Pump job handlepercent_done NUMBER; -- Percentage of job comp ...

Oracle Data Pump > ORA-39152: Table "FA"."FA_ADJUSTMENTS" exists.

I ran an import using Oracle Data Pump (impdp) command and at the end I got the message:Job "APPS"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 12:23:36The error reads: ORA-39152: Table "FA"."FA_ADJUSTMENTS" exists. Data will be appended to existing table but all dependent metadata will be ski ...

Oracle ORA-12560 error when trying to do a data pump

I installed oracle 11g and was attempting to do a data pump from the dev machine to my computer however when I run the impdp command I get an ORA-12560: TNS:protocol adapter error. A co-worker thought I might need to add a loopback adapter as that had been the only thing different from his machine w ...

Oracle Data Pump import to a sql file error :ORA-31655 no data or metadata objects

I'm using Data Pump to export/import data, one requirement is to import data to a sql file. The OS is window.I made the follow export :expdp system/password directory=dpump_dir dumpfile=tablesdump.dmp content=DATA_ONLY tables=user.tablenameand it works, I can see the file TABLESDUMP.DMP in the direc ...

Oracle ORA-39097:Data Pump job encountered unexpected error -1089, DumpFile Import

we have partitioned table, with DATA pump we generated DMP file and now trying to restore it back with datapump import failed with api and with impdp utilities as well.declare h1 NUMBER; begin h1 := DBMS_DATAPUMP.open( operation => 'IMPORT', job_mode => 'TABLE', job_name => 'P2010061100'); ...

Oracle Data Pump Import GeoRaster table cause ORA-13497

I ran Data Pump Export to export a schema from one database, copied the dmp file over to another database machine, and ran Data Pump Import to import into the same schema. The process went through. However, when I tried to validate GeoRasters loaded, I got the following error for every GeoRaster obj ...

Oracle Data pump error

When importing data from dump file using data pump,Im getting error like theseora-00054:resources busy and acquire with nowait specified ora-00995- name is already used by an existing objectsKindly help me out ...

Oracle During import ora-01917 user or role does not exist "High Priority"

When i import the data the following error occured.imp system/xxxx@yyyy.world fromuser=dmv_ace_ruh touser=dmv_ace_ruh file=F:\dmvaceruh.dmp log=F:\dmvaceruhimp.log ignore=y fromuser=dmv_ace_ruh (exported by another database i.e database name is ACE)OS = Sun solaristouser=dmv_ace_ruh (database name i ...

Oracle Best Practice for data pump or import process?

We are trying to copy existing schema to another newly created schema. Used export data pump to successfully export schema. However, we encountered some errors when importing dump file to new schema. Remapped schema and tablespaces, etc. Most errors occur in PL/SQL... For example, we have views like ...

Oracle Problem with Data Pump (v.10.2.0.2.0)

i have a Problem with Data Pump Export - while exporting error accrues: "invalid VERSION Parameter '10.02.00..00' for object type ..." although my Command-Line isexpdp user/password@sid dumpfile=DATA_EXPORT_DIR:test_export_metadata_20100202.dmp VERSION=10.1 logfile=DATA_EXPORT_DIR:test_export_metada ...

Oracle Data pump error

I am trying to import database dump using the following commandimpdp system/xxxx@xxxx schemas=staging remap_schema=staging:staging directory=DUMPDIR dumpfile=staging.dmp logfile=impdpstaing.log TRANSFORM=SEGMENT_ATTRIBUTES:n Its importing data fine upto some stage after that oracle gives the followi ...

Oracle Data Pump Error

Below is the error in the data pump log. Can someone please help me figure out what it means and how I can fix it. Is it the PLS-00306 error that is making it not work?SCHEMA_EXPORT/JOBORA-31693: Table data object "DA"."PYGLEDGER_HIST" failed to load/unload and is being skipped due to error:ORA-0235 ...

Oracle Cannot import data pump export into XE11 - bug?

I've just installed XE11g on Windows 2008R2 standard server edition and everything went apparently well.After fixing certain firewall rules I managed to connect to XE from SQL Developer running on a Mac and also to Apex, I could successfully create workspaces and import apex applications without pro ...

Data Pump Globalization Support

Does anyone know how Data Pump works with character set ??? For example, should the server's character set different from the one client's using, how would the data be transferred ??When exporting, whose character set would be used in the process ?? Server's or client's ??And how about importing ??? ...

Oracle Data pump import (impdp) broken on 10G Standard Edition?

I can not get data pump import to work on standardedition (10.1.0.3 on RedHat ES 4)I always get a "ORA-00439: feature not enabled: Streams Capture" even if I just start impdp withoutspecifying any dump files on the command line('impdp nnn/password')I know Streams capture is an Enterprise Ed. only fe ...

Oracle 10g data pump utility

I'm using the data pump utility expd to export a 10g database. This function is run on a regular basis as a cron job. It used to work fine before. Now every time it fails with ORA-31626: job does not existORA-31633: unable to create master table "OPS$ORACLE.EXP_DEVCOR10_FULL" ORA-06512: at "SYS.DBMS ...

Oracle data pump cannot export schema

Using data pump under oracle 10.1. I cannot perform a full export of a schema;expdp scott/tiger schemas=hist directory=DATA_PUMP_DIRI get this errorConnected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining Scoring Engine opt ...

Oracle Data Pump...no data found error

This is my first time using Data Pump.Loading employees, their addresses and assignments into ORACLE HRMS. The load is erroring out every time i attempt to load the grade, position, job, payroll and organisation.What's happening is for each value that i want to load, the hire date (or effective date ...

Oracle data pump remap_user, index errors.

I am importing with data pump:impdp user/pwd@db schemas=USER1 DUMPFILE=USER1.dmp directory=EXP_DIR LOGFILE=USER1.log REMAP_SCHEMA=USER1:USER2 remap_tablespace=USER1_T:USER2_T remap_tablespace=USER1_I:USER2_IRunning Oracle 10.2.0.2Oracle seems to import correctly, however I get a lot of errors on ind ...

Oracle Data Pump impdp DIRECTORY object for dumpfiles on shared network drive

Our customer has delivered Data Pump dumpfiles to a Linux Server where Oracle is not installed. We are attempting to use impdp from a Windows 2003 Server with Oracle release 10.2.0.3 installed. The following steps have been taken:1) Established a DIRECTORY object DATA_PUMP_DIR and verified that it w ...

Oracle Data Pump Import File Permission

I am trying to do a data pump import on a Sun OS box. I have a dumpfile that is no longer owned by the Oracle user, or the group the oracle user belongs to. What file permissions are needed on ths dumpfile for data pump import to work. Here is the error I received:Connected to: Oracle Database 10g E ...

Oracle Data Pump in 10G

We were trying to import data using data pump process. We got the following exception.Processing object type SCHEMA_EXPORT/TABLE/TABLEORA-39014: One or more workers have prematurely exited.ORA-39029: worker 1 with process name "DW01" prematurely terminatedORA-31672: Worker process DW01 died unexpect ...

Oracle Address Range Not Readable During Data Pump Import

We're trying to import a table via Data Pump in an 11i 10g (10.2.0.2) DB running on HPUX Itanium and receive the error below. Any ideas where to go from here?Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsM ...

Oracle data pump PL SQL API ;;; PLZ HELP ME

I want to use the data pump PL SQL API provided by Oracle ; I have created one procedure named SP_EXPORT as showing below ;But the problem that I have this error message : any suggestion, help please ? ORA-31626: job does not existORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512: at "SYS.DBMS_DA ...

Oracle Can data pump handle export/import of a sequence explicitly?

Is it possible to just export/import a database sequence explicitly using data pump.I know we can export/import sequence by exporting/importing the user in which it is defined.However I am looking for a way to export/import individual sequnces without having to export/import the entire user. ...

Oracle Data Pump Export errors

Database : 10.2.0.3.0Trying to execute Full Database Data Pump Export job and getting following errors:Processing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/TABLESPACE_QUOTAProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAORA-39014: One or more workers ha ...