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
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What are statistics, under what circumstances they go out of date, how do you update them?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What the different types of replication and why are they used? : 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.
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you create a user-defined lock?
What are the different types of indexes available in sql server? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Query processing is slow(eg select query)how will u solve that
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What the different topologies in which replication can be configured? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What is the difference between clustered and non-clustered index? : sql server DBA
how to restore files with rman?