:

RSSData Pump

ORA-39165: Schema SYS was not found

Oracle Version: 10.2.0.4 Platform: Windows Server 2003 R2 The Problem I was attempting to export a table from an Oracle version 10.2 DB running on Windows. I was using the data pump export utility instead of the older export utility. The table which I wanted to export resided in the SYS schema. When running the […]

Continue Reading

ORA-27038 Dump File Already Exists

Oracle Version: 11.2.0.3 Platform: Windows Server 2003, SP2 The Problem When running a data pump export job you get the error listed below: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 With the Partitioning and Real Application Testing options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: unable to create dump file “USER_EXP.dmp” ORA-27038: […]

Continue Reading

ORA-31626: job does not exist

The Problem We have a scheduled data pump job which runs every month to export an old partition of a table which we subsequently drop – it’s no longer needed in the application but we keep it as an export just in case we need to get the data back for some reason. Anyway, this […]

Continue Reading

ORA-39041: Filter “INCLUDE” either identifies all object types or no object types

Data Pump is a very powerful tool and a great improvement over the original export and import utilities in early versions of Oracle. With the 10g version of data pump, you can filter objects to very specific levels, stating what you want to include and exclude within your export and import. For example, you can […]

Continue Reading

The value (30) of MAXTRANS parameter ignored

I came across the valu (30) MAXTRANS parameter ignored error Oracle error when using datapump to import data into my 11g database. It is covered in Metalink note ID: 455021.1. The short of it is that a table is trying to be created like this: create table testing (col1 number) initrans 10 maxtrans 30; The parameter […]

Continue Reading

Data Pump Import Hangs – Inactive

When running an import using data pump, the session logs on but doesn’t do anything. The only message present within the alert log is this: kupprdp: master process DM00 started with pid=24, OS id=7244 to execute – SYS.KUPM$MCP.MAIN(‘SYS_IMPORT_SCHEMA_01’, ‘SYS’, ‘KUPC$C_1_20100416103259’, ‘KUPC$S_1_20100416103259’, 0); It took me a while to realise it but there was no TEMP […]

Continue Reading

UDE-00014: invalid value for parameter, ‘schemas’

When using the data pump utility with the QUERY parameter to export only a subset of the data, I ran into the error: UDE-00014: invalid value for parameter, ‘schemas’ As it turns out, you cannot fully qualify the table names within your QUERY statement. The reason for this seems to be because you can only […]

Continue Reading

ORA-31641: unable to create dump file

The Problem You are attempting to execute the data pump utility and export some data from your database but when you run the command which was previously working without any errors you receive the following error: ORA-31641: unable to create dump file “C:\Temp\export.DMP” The Cause There will, most likely, already be a file name “export.DMP” […]

Continue Reading

ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

The Problem When running a data pump export job, I received the following error message: ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes Job “SYS”.”SYS_EXPORT_TABLE_01″ stopped due to fatal error at 12:09:55 The Cause Because I wanted to make my imports faster I had set the parallel parameter on the import […]

Continue Reading

ORA-39125: Worker unexpected fatal error in KUPW$WORKER

The Problem I was using our physical standby database to run a data pump export job. I had created a guaranteed restore point so that I was able to flashback the DB to its original state but I was not able to get the export working. There was no real error message on the screen. […]

Continue Reading