Tag Archives: OMF

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile

In your data center, Oracle Managed Files (OMF) is used for all databases.All tablespaces are smallfile tablespaces.SALES_Q1 is a permanent user-defined tablespace in the SALES database.Examine this command which is about to be issued by a DBA logged in to the SALES database:ALTER TABLESPACE sales_q1 ADD DATAFILE;Which are two actions, either one of which you could take to… Read More »

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile

In your data center, Oracle Managed Files (OMF) is used for all databases.All tablespaces are smallfile tablespaces.SALES_Q1 is a permanent user-defined tablespace in the SALES database.Examine this command which is about to be issued by a DBA logged in to the SALES database:ALTER TABLESPACE sales_q1 ADD DATAFILE;Which are two actions, either one of which you could take to… Read More »