How do you set up tablespaces during an oracle installation?
No Answer is Posted For this Question
Be the First to Post Answer
What skills do you need to be an administrator?
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?
When using oracle export/import what character set concerns might come up? How do you handle them?
Can you remove an open file under unix?
What exactly does a dba do?
What file will give you oracle instance status information? Where is it located?
What parameters control copy latches?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
What does a dba stand for?
How do you set up your tablespace on installation level: low?
Give one method for transferring a table from one schema to another?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?