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 commands you'd issue to show the explain plan for "select * from dual"?
What are the different sql server versions you have worked on? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Query processing is slow(eg select query)how will u solve that
What the different topologies in which replication can be configured? : sql server DBA
when does an alert gets signaled?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
who owns the operating system files created by the utl_file package?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what is the use of ocr?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is dcl? : sql server DBA
how can you record information about current session?
Can you redefine a table online?