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 220.127.116.11 to 18.104.22.168 [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
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
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