If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
Tell me about standby database? What should we watch out for?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
What are the steps involved in instance recovery in oracle?
What is oracle log switch?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
How do I call oracle stored procedures that take no parameters?
How do I learn what codesets are available in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How do I limit the number of oracle database connections generated by weblogic server?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Why does for update in oracle 8 cause an ora-01002 error?
How to pipe multiline string to isql?