Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

why should i set global_name=*'TRUE'*

972355Apr 25 2013 — edited Apr 25 2013
if I create public database link its should be TRUE, What's the logic here ?

SQL>show parameter global_name;

NAME TYPE VALUE
global_names boolean FALSE

SQL>create public database link mydba connect to scott identified by tiger using 'ORCL';

Database link created.

SQL> select * from emp@mydba

select count(*) from emp@mydba;

COUNT(*)
14

Even i set global_name='FALSE' i can create public database link. then
why should i set global_name=*'TRUE'*
This post has been answered by unknown-7404 on Apr 25 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2013
Added on Apr 25 2013
14 comments
1,223 views