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 export command I received the following errors:

ORA-39165: Schema SYS was not found.

ORA-31655: no data or metadata objects selected for job

I double checked that the object existed and it did, so I couldn’t understand why it didn’t export. I ran the same export command against a table which resided in a different schema and it worked without a problem. I checked through the alert log and found a couple of warnings:

The value (30) of MAXTRANS parameter ignored.

kupprdp: master process DM00 started with pid=339, OS id=11304

to execute – SYS.KUPM$MCP.MAIN(‘SYS_EXPORT_TABLE_01’, ‘SYS’, ‘KUPC$C_1_20111006091237’, ‘KUPC$S_1_20111006091237’, 0);               kupprdp: worker process DW01 started with worker id=1, pid=342, OS id=9204

to execute – SYS.KUPW$WORKER.MAIN(‘SYS_EXPORT_TABLE_01’, ‘SYS’);

These were nothing to worry about, as I have written in another article The value (30) of MAXTRANS parameter ignored

The Cause

The cause is that the data pump utility cannot export data from the SYS schema, or other high level DB users…

The solution

I had to use the original export utility to export the data that I needed.

Like it, share it...

Category: Data Pump