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?
546Post New Oracle DBA (Database Administration) Questions
Explain force logging feature in 9i.
What are the important tasks of common oracle dba?
What are the different types of backup available in the oracle?
What are the different responsibilities of a dba?
While taking hot backup (begin end backup) what will happens back end?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
When should an artificial (or derived) primary key be used?
What does database administrator do?
What are types of data model?
You see a wait on lms process in statspack, what does that mean?
What is the difference between a database and instance? What is the relation between them?
How can you tell if a tablespace has excessive fragmentation?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
what does the no logging option do? Why would we use it?
How would you find total size of database in os level?