Answer / robertson

HOW TO CREATE BACKUP CONTROL FILE;
In the primary server
sql>alter database backup controlfile to trace;

It gets created in the user_dump_dest path.
sql>show parameter user_dump_dest

HOW TO CREATE STANDBY CONTROL FILE;
In the primary server
sql>alter database backup controlfile
to '/uo1/app/bkpctrl.ctl';

Then ftp the file to the standby controlfile.

Rename the standby controlfile witht the primary file.

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---

Explain the use of table functions.

0 Answers  

---

What is mrc and what is its use? : oracle accounts receivable

0 Answers  

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers  

---

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

---

How do you resize a data file?

2 Answers  

---

what is sql*loader parameters and where we will use it.

1 Answers   Accenture,

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  

---

Explain how to close periods in ar. : oracle accounts receivable

0 Answers  

---

How can you rebuild an index?

1 Answers  

---