CTAS USING DBLINK FAILS WITH ORA-2019 on Streams Apply Site
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 126.96.36.199
This problem can occur on any platform.
CREATE TABLE ...AS SELECT (CTAS) command with Database link is not getting replicated on apply site where remote Site that connects via database link is Oracle Database.
Streams apply process was failing with Ora-2019 error even if database link is present on Streams administrator & Replication schema user.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms