Oracle Management Files is the feature allow oracle instance manage the database file, such as the tablespace file. It can name the files base on the OFA rule in the predefine location and delete the file when the file is no longer require in the even such as drop tablespace. It is new feature available after Oracle 9i.
DB_CREATE_FILE_DEST | Require | Data File, Temporary File, Block Change Tracking File. When no DB_CREATE_ONLINE_LOG_DEST, it can be use by control file and log file |
DB_CREATE_ONLINE_LOG_DEST_n(1~5) | Optional | Control File, Log File. |
DB_RECOVERY_FILE_DEST | Optional | Default location for Archive log and RMAN backup files |
When DB_CREATE_FILE_DEST is not set, the OMF is not enable.
-- If no db_create_file_dest is set, the OMF is not enable
show parameter db_create
show parameter db_recovery
Enable the OMF
-- If OMF is not enable, below "create tablespace" would fail
Create tablespace mytbs;
alter system set db_create_file_dest='/home/oracle/app/oracle/oradata/orcl';
-- Re create the tablespace
Create tablespace mytbs;
-- Query the tablespace
col tablespace_name format a21
col "FILE_NAME" format a20
select DT.TABLESPACE_NAME,DT.contents,DT.STATUS,DT.SEGMENT_SPACE_MANAGEMENT, DT2.FILE_NAME,DT2.BYTES
from DBA_TABLESPACES DT, DBA_DATA_FILES DT2
where DT.TABLESPACE_NAME= DT2.TABLESPACE_NAME and DT.TABLESPACE_NAME='MYTBS';
-- drop tablespace
drop tablespace MYTBS;
Reference
http://docs.oracle.com/cd/B10501_01/server.920/a96521/omf.htm
Gli orologi economici orologiRolex sono realizzati con le migliori materie prime e sono accuratamente realizzati. replica rolex explorer orologi replica rolex datejust orologi Ogni componente è progettato, sviluppato e prodotto internamente secondo gli standard più severi.
ReplyDelete