THe parameter DB_FILES is located in initorcle.ora and parameter MAXDATAFILES you specify at the time of database creation. This parameter shows that this much number of datafiles yo can create. DB_FILES takes precedence on MAXDATAFILES.
For your second question about recovery of table there may be two solution ....Either you know the time when the table was dropped so that you perform incomplete recovery until time the table was dropped, but this will be at the expense of loss of data from that time to present. One more solution is TSPITR (Tablespace point-in-time recovery) but it's rather complicated one...You have to export your database, make a clone database, apply incomplete recovery of clone database, import the recovered clone database and start your main database with RESETLOGS.
You cannot succeed if you fear to face challenges.
MAS
BE(CS) , OCP 8/8i.
When you run CREATE DATABASE, you often have a parameter called MAXDATAFILES. The value that is entered for this parameter or some default value is stored in the CONTROL FILE upon DB creation. This is the so called "hard" limit on the number of datafiles which can be associated with this particular database. Remember DB, not instance!
In the init.ora you have DB_FILES. This is the limit on the total number of files associated with a particular INSTANCE of a database. As you know several instances can be associated with a single DB. This is called the "soft limit".
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
email: ocp_9i@yahoo.com
Reply With Quote
Bookmarks