You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
Answer Posted / anonymous
Have to manually create a new control file.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you communicate with operating system files from oracle?
how can you schedule a job in database?
how can you initialize log miner?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you connect from 10g user to 11g user??
Why would you call update statistics? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Why does Oracle not permit the use of PCTUSED with indexes?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the commands used in dcl? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How would you extract DDL of a table without using a GUI tool?