answersLogoWhite

0


Best Answer

There can as many as the Operating System will support.

The limitation of "how many" is set by the OS and not the database.

Two Oracle parameters to research that are related to your question however.... db_files, and maxdatafiles

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How many max data files can there be in an Oracle Database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How much data store in oracle database?

Oracle has many versions like 9i, 10g, 11g, 12c .Oracle database can store infinte data unless you have put any restriction on it.


What is the difference between oracle and oracle erp?

Oracle is a database corporation that has many products such as Database, BI and ERP


What is the function of an SQL Loader?

SQL Loader is a utility used to load data from external files into an Oracle database. It can handle loading large volumes of data quickly and efficiently, and provides flexibility in mapping data from files to database tables. It is commonly used for bulk data loading tasks.


What is an oracle and what does it do?

Oracle is one of the popular database. It grows by adding many supporting tools like client tools (Developer 2000), Enterprise manager (admin), Designer tools,ERP etc. In simple, it stores your data, manipulate. You may check my profile there is a link to my oracle faq site. It will give you some idea about oracle. Also google to more information.


Why was it so difficult for IRS to analyze the taxpayer data it had collected?

Initially, IRS data were stored in legacy systems designed to process tax return forms efficiently and organized in many different formats, including hierarchical mainframe databases, Oracle relational databases, and non-database "flat" files. The data in the older style hierarchical databases and "flat" files were nearly impossible to query and analyze and could not easily be combined with the relational data.


How many Maximum Datafiles can there be in an Oracle Database?

there can as many as the operating system will supports


What are examples of data base software?

The database is a collection of data which we can perform operations, a structured set of data held in a computer, especially one that is accessible in various ways.A simple example for a database would be the record of all employees of CNN international on their payroll and storing data. Mr Gulfam Haidar used this


What is the differences between altibase and oracle?

Oracle has many products, but presumably you are referring to either 11g or 12c. The difference between Oracle and Altibase is that Oracle is a traditional disk-based database while Altibase is an in-memory database. As an in-memory database, Altibase is significantly faster than Oracle. One way to look at this is Oracle's buffer cache. Oracle uses the buffer cache to significantly increase read speeds by keeping the data in memory. However, this has no impact on updates, deletes, or inserts, whereas Altibase enjoys these performance enhancements across the board. Altibase differentiates itself from other in-memory databases by marketing itself as a hybrid. This allows it utilize both an in-memory database and disk database using a single engine, which allows it enjoy the speed benefits of in-memory databases while also utilizing cheaper disk-based storage for rarely queried data. In many ways however, the two databases are very similar as they are both ACID compliant relational databases.


Is database software or hardware?

A database is an integrated collection of logically related records or files which consolidates records into a common pool of data records that provides data for many applications. A database is a collection of information that is organized so that it can easily be accessed, managed, and updated


What are the differences between Access and Oracle?

The difference between Access and Oracle is Access has minimum security features and you can create a small to medium sized database. Oracle has NY security, which allows you to determine who can or can not get access to your data. Access you can't add too many users without it getting slow, and Oracle allows you to add thousands if you want to.


How many finger prints are in the FBI master database of criminal files?

The FBI's Integrated Automated Fingerprint Identification System (IAFIS) contains over 70 million criminal fingerprints and over 34 million civil fingerprints.


What is Toad for Oracle used for?

Toad the Oracle is a database tool. It is probably the most well known and commonly used Oracle DBA software that you will find. You can find many websites devoted to Toad for Oracle.