My Oracle Support Banner

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

Last updated on DECEMBER 31, 2019

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


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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.