SQL> show parameter global_names
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ global_names boolean FALSE SQL> select * from dual@test; select * from dual@test * ERROR at line 1: ORA-02085: database link TEST connects to ORCLlocal SQL> alter session set global_names=FALSE; Session altered. SQL> select * from dual@test; D - XSQL> alter system set global_names=FALSE sid='*' scope=both;
System altered.
SQL> exit
Disconnected from Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@localhost ]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 26 12:33:26 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> conn testusr/testusr@TRGTDB
Connected.
SQL> select * from dual@test;
D
-
X
No comments:
Post a Comment