Database Utilities (MOSC)

MOSC Banner

Exporting 10.2.0.3 into 11.2.0.3 with the old exp and imp

edited Sep 28, 2012 4:43AM in Database Utilities (MOSC) 7 commentsAnswered

We recently installed 11.2.0.3 on windows 2003, we currently have 10.2.0.3

Some of our databases will change servers , so we will do a export from 10g and import into 11g

When I tried to use expdp under 10.2.0.3 , it failed with the following error

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
.

I found a couple of notes indicating that ther might be a patch 5879865  for this.

But as a workaround I tried using the old export "exp" and it worked fine , then I use the old import "imp" to import in 11.2.0.3

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center