My Oracle Support Banner

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 later
Information 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


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