IMPDP Of a Dump File Containing Versioned Tables Raises ORA-39083 and ORA-20182 (Doc ID 1325377.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Workspace Manager - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 07-Nov-2012***

Symptoms

A FULL database export of a database containing versioned tables has been created with EXPDP tool,  including the WMSYS schema.

When the dump file is imported into the target database using the command

impdp system DIRECTORY=DATAPUMP_DIR DUMPFILE=fullexp.dmp table_exists_action=truncate LOGFILE=fullimp.log FULL=Y


several errors

Failing sql is:
CREATE FORCE VIEW "USER"."TABLE" ("COL1", "COL2", "COL3", ....
ORA-39083: Object type VIEW failed to create with error
ORA-20182: attempt to modify a WM generated view
ORA-06512: in "WMSYS.WM_ERROR", line 338
ORA-06512: in "WMSYS.WM_ERROR", line 346
ORA-06512: in "WMSYS.NO_VM_CREATE_PROC", line 52
ORA-06512: in line 19
ORA-00942: Table or View does not exist

are raised.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms