Explain the use of setting GLOBAL_NAMES equal to TRUE.
Answer Posted / guest
While this variable does not directly store a value that
you can identify your database with, it does dictate how
you might connect to a remote database. This variable is
either TRUE or FALSE and if it is set to TRUE it enforces
database links to have the same name as the remote database
to which they are linking.
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
how can you process messages in order asynchronously?
What happens on checkpoint? : sql server DBA
What is a system database and what is a user database? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how can you record information about current session?
Can you redefine a table online?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What the different types of replication and why are they used? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you connect from 10g user to 11g user??