Answer Posted / abitha

Control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation.

Control file contains:
Database information
Archive log history
Redo threads
database name
Current archive log mode
Database's creation date etc.,

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2188

---

How do I limit the number of rows returned by an oracle query after ordering?

1228

---

How to initialize variables with default values?

1308

---

Is rowid unique in oracle?

1048

---

What happens if the imported table already exists?

1078

---

How to sort the query output in oracle?

1076

---

How to pass a cursor variable to a procedure?

1160

---

What is parameterized cursor in oracle?

1224

---

How to name query output columns in oracle?

1245

---

How to put more than 1000 values into an oracle in clause?

1086

---

How to drop an index in oracle?

1121

---

How to export your own schema?

1051

---

 How to use an oracle sequence generator in a mapping?

1133

---

How to write a query with an inner join in oracle?

1097

---

What is meant by recursive hints in oracle?

1134

---