ORA-0173 And ORA-02063 When Updating A View With DBLINK
(Doc ID 2561237.1)
Last updated on DECEMBER 29, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
When inserting or updating views in the remote site using dblink, the following error happened.
ORA-01732 data manipulation operation not legal on this view ORA-02063 preceding line from <DBLINK_NAME>
If use the DML on table instead of view in the remote site, no error happens.
Created a view with order by clause.
CREATE OR REPLACE VIEW <view_name>
ORDER BY ... <-----!!!
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