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
How would you extract DDL of a table without using a GUI tool?
What are the different sql server versions you have worked on? : 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 implement fine-grained auditing?
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
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what is the use of ocr?
what is ora 24313?what is the procedure to exclude that error?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
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
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How would you best determine why your MVIEW couldn't FAST REFRESH?