Can Not Create/Refresh Snapshots Ora-12703
(Doc ID 259506.1)
Last updated on MARCH 10, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 9.0.1 to 9.2]
Information in this document applies to any platform.
The snapshot database has NLS_CHARACTERSET=AL32UTF8
The master database has NLS_CHARACTERSET=UTF8
On remote site:
create COMPLETE snapshot, works fine
create REFRESH FAST WITH ROWID gets ORA-12703
create REFRESH FAST WITH PRIMARY KEY gets ORA-12028
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!