1. Run Script on Remote DB:
CREATE table view_test
(a number, b number, c char(1))
/
INSERT into view_test values
(1,2,'X')
/
INSERT into view_test values
(4,5,'Y')
/
CREATE table view_test2
(a number, b number, c char(1))
/
INSERT into view_test2 values
(10,11,'Y')
/
INSERT into view_test2 values
(100,11,'Y')
/
CREATE or replace view view_test_layer1
AS SELECT * from view_test
union
SELECT * from view_test2
/
exit
2. Set up DB link to Remote DB on Local DB.
3. Run Script on Local DB :
CREATE or replace view view_test_layer2
AS SELECT * from view_test_layer1@remoteDBLinkName
/
4. Run SQL Monitor.
5. Open Schema Browser, click on Views tab.
6. Results in an ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc.
ORA-02063: preceding line from REMOTEDBLINKNAME in TOAD are not able to view the View.
SQL Monitor detects the error.
WORKAROUND
Go to View >> Options.
Data Grids - Data.
Check Default to Read Only Queries.
STATUS
Waiting for fix in a future release of TOAD.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center