How to recover the DB if we lost controlfile and we are not having backup also and the database is down...?
Latest Answer: FTS means the oracle server reads all the records from the concerned table. And it all depends on the size of the table/ partitioned table. What you say if a table consists of 10 million of records. so we musr avoid FTS. And after all Oracle is ...
Latest Answer: Generally a database refresh is done on the same server. A database refresh is just like defragmentation in windows so that the space can be utilized more efficiently and performance also improves since the data of a segment is brought into a single extent.Generally ...
Latest Answer: A Transaction is a logical unit of work that comprised one or more sql statements. where as scn is system change number, When a transaction commits a scn will be generated. ...
What is the differences between DBMS & RDBMS? What is the differences between Oracle & MS Access?
Latest Answer: he can kill the process using kill command at OS level. ...
Latest Answer: Log shipping transfers database dumps and logs from the primary server to the secondary server. As with any warm standby solution, failure detection and failover processing is not automated. When log shipping is employed, the standby database cannot be ...
Latest Answer: hi,create role in database with proper permission. then assign that role to the user. This is the simplest method to implement secuirty in database. ...
Latest Answer: Dear Pooja your answer is correct. And please write the answer in steps wise or by paragraphs wise.Regardskumar ...
Latest Answer: buffer busy wait is the condition in which oracle server has to wait to access the segment header block for the table on which concurrent insert or delete operation r to be done.the segment header block contains control info including header link for ...
View page << Previous 1 2 3 [4] 5 6 Next >>
Go Top
