Last updated on FEBRUARY 08, 2017
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.
***Checked for relevance on 07-Nov-2012***
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms