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 JANUARY 30, 2022

Applies to:

Workspace Manager - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.


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:
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.


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

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