IMPDP Of a Dump File Containing Versioned Tables Raises ORA-39083 and ORA-20182
Last updated on FEBRUARY 08, 2017
Applies to:Workspace Manager - Version 188.8.131.52 to 184.108.40.206 [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