Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error "ORA-39029: worker 1 with process name "DW01" prematurely terminated"

user613483Oct 9 2008 — edited Oct 9 2008
Hi,

I get this error during an import from my production database schemas into my development schemas:

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Message 31672 not found; No message file for product=RDBMS, facility=ORA; arguments: [DW01]
Job "SYS"."SYS_IMPORT_FULL_01" stopped due to fatal error at 12:57:47
ORA-39014: One or more workers have prematurely exited.

This is my parfile:

PARALLEL=1
remap_SCHEMA=xxx:xxx
remap_tablespace=yyy:yyy
DUMPFILE=file.dmp
LOGFILE=imp_file.log
DIRECTORY=dddd
TRANSFORM=oid:n

I try to import with sys and system user.

I can't find anything about this error.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2008
Added on Oct 9 2008
7 comments
5,162 views