You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
No Answer is Posted For this Question
Be the First to Post Answer
How do you set up your tablespace on installation level: low?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What does database administrator do?
Which dba certification is best?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
How can be determining the size of the log files?
How do you set up tablespaces during an oracle installation?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
How do you use automatic pga memory management with oracle 9i and above?
What are the daily activities of oracle dba?
What are types of data model?
How does one coalesce free space?