You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles:

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?

Question Posted / rajwant kumar

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle DBA (Database Administration) Interview Questions

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

How many types of dba are there?

What are types of data model?

Why are recursive relationships bad? How do you resolve them?

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

I am getting error "no communication channel" after changing the domain name? What is the solution?

How do you set up tablespaces during an oracle installation?

How do I become a dba?

What are the different types of backup available in the oracle?

What are the possible ways to gain information regarding the control file?

Does a dba have to file taxes?

What does a senior database administrator do?

For more Oracle DBA (Database Administration) Interview Questions Click Here