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 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
When inserting or updating views in the remote site using dblink, the following error happened.
ERROR
-----------------------
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.
Changes
Created a view with order by clause.
e.g.
CREATE OR REPLACE VIEW <view_name>
(
...
)
AS
SELECT ...
...
FROM <table_name>
WHERE ...
ORDER BY ... <-----!!!
Cause
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
Symptoms |
Changes |
Cause |
Solution |