Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of Control File ?
- 3 Answers
- 6523 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
control file contains crucial information regarding the
database.Without control file u can't open the database.
It maintains integrity of database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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.,
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
Controlfile contains the information about the database like names and locations of datafiles, name of the database, database creation timestamp and apart from this the SCN are also reported into control during the database operation. Especially during the database startup the controlfile is used to gather the information about the database and while opening the database the information in the controlfile is validated to check for the consistency of the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
how can we store any pdf file in oracle
What are the different type of Segments ?
What do you mean by merge in oracle and how can we merge two tables?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Where is the export dump file located?
How to define Data Block size ?
What is an Integrity Constrains ?
Give syntax for SQL and ORACLE joins.
Explain the difference between a procedure and a function? What do you understand by those terms?
a query to select maxmun 3 salaries of employee table
Oracle General 
