If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---