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 statistics, under what circumstances they go out of date, how do you update them?
what do you understand by flashback feature of oracle?
when does an alert gets signaled?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is the use of ocr?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you find out if a table can be redefined?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Where would you look for errors from the database engine?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is the difference between clustered and non-clustered index? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
suppose you want to audit specific activities on sensitive data. How can you achieve that?