How many max datafiles can there be in an Oracle Database.

Mohit tayal

• Mar 20th, 2016

Max. database file per database is 65533.
Max. Datafile per tablespace 1022

Somesh Menaria

• Feb 22nd, 2016

In 11g we can use 1022 datafiles

Answer Question  Select Best Answer