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?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between cold backup and hot backup?
You see multiple fragments in the system tablespace, what should you check first?
What is the relation between database and instance?
How do you set up tablespaces during an oracle installation?
How can you determine if an oracle instance is up from the operating system level?
What is oracle log switch?
System tablespace cant be exported from one database and imported into another why?
As an oracle dba what are the entire unix file you should be familiar with?
What happens if the constraint name is left out of a constraint clause?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
When using oracle export/import what character set concerns might come up? How do you handle them?