datafile maxsize when using Oracle Managed Files (OMF)
Hi,
I am a newbie in Oracle11g and trying to learn for OCA.
It is stated in the doc that maxsize is unlimited when using OMF.
"By default, an Oracle managed datafile for a permanent tablespace is 100 MB and is autoextensible with an unlimited maximum size"
I installed Oracle 11.2.0.3 on windows server 2008 64-bit and tried to use OMF, but the maxsize is set to 32Gb.
SQL> select file_name, maxbytes from dba_data_FILES WHERE tablespace_name LIKE '%OMF%';
FILE_NAME : <somepath>\O1_MF_TEST_OMF_8XFDZLNS_.DBF
MAXBYTES : 34359721984 (=32 Gb)
Can somebody help me to understand what's going on?
0