we use oracle 11.2 with OMS(oracle managed files) for database in linux platform. the parameter--DB_CREATE_FILE_DEST had been set . right now, we got a warming message that tablespace test is 85% full.
according oracle document, OMF will auto add a data file into tast tablespace. over one weeks, I do not see any data file have been added by OMF.
I want to know when does OMF add data file into tablespace? 85% or 95% or some setting (parameter) control this action?
Once the first datafile is full, the database does not automatically create a new datafile. More space can be added to the tablespace by adding another Oracle-managed datafile. The following statement adds another datafile in the location specified by
As my understand, DBA needs to run below command
ALTER TABLESPACE test ADD DATAFILE;
OMF doesn't automatically add a new datafile. You have to explicitly add a new datafile with the ALTER TABLESPACE tbsname ADD DATAFILE command.
What OMF does is to provide a Unique Name and a Default Size (100MB) to the datafile. That is why the ALTER TABLESPACE .. ADD DATAFILE command that you run does not need to specify filename or filesize.
Hemant K Chitale