ORA-0173 And ORA-02063 When Updating A View With DBLINK (Doc ID 2561237.1)

Last updated on DECEMBER 29, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.