Friday, May 20, 2011

Simplified database file creation using OMF


OMF (Oracle Managed Files) in oracle is used to simplify creation of database files as Oracle does all OS operations and file naming. It helps:

·         Automatic cleanup of the filesystem when database objects are dropped.

·         Standardized naming of database files.

·         Increased portability since file specifications are not needed.

·         Simplified creation of test systems on differing operating systems.

·         No unused files wasting disk space.

The location of database files is defined using the DB_CREATE_FILE_DEST parameter

ALTER SYSTEM SET DB_CREATE_FILE_DEST=’D:\oracle\oradata\testdata\OMF\’;

Files typically have a default size of 100M and are named using the following formats where u% is a unique 8 digit code, g% is the logfile group number, 
and %t is the tablespace name:

File Type
Format
Controlfiles
ora_%u.ctl
Redo Log Files
ora_%g_%u.log
Datafiles
ora_%t_%u.dbf
Temporary Datafiles
ora_%t_%u.tmp

Example:

Create tablespace test_omf;

The resultant datafiles will have a default size of 100M and AUTOEXTEND 
UNLIMITED.

CREATE TABLESPACE test_omf DATAFILE SIZE 150M;

ALTER TABLESPACE test_omf ADD DATAFILE;

DROP TABLESPACE test_omf

:-)

17 comments:

Anonymous said...

buy xanax online xanax bars yellow vs white - xanax street price 1 mg

Anonymous said...

buy zolpidem online buy cheap zolpidem no prescription - zolpidem prices walmart

Anonymous said...

diazepam online cheapest diazepam online - erowid com diazepam

Anonymous said...

buy xanax buy xanax online legit - buy xanax online no prescription cheap

Anonymous said...

buy diazepam diazepam in dogs dosage - diazepam valium drug class

Anonymous said...

buy ativan online ativan for alcohol hangover - lorazepam no prescription overnight delivery

Anonymous said...

discount ativan ativan no prescription online pharmacy - better high ativan or klonopin

Anonymous said...

can you buy xanax online legally xanax 10 mg generic - withdrawal short term xanax use

Anonymous said...

buy xanax 2mg xanax dosage before mri - buy xanax alprazolam

Anonymous said...

buy diazepam buy diazepam 5mg online - diazepam 10 mg ervaringen

Anonymous said...

ativan sale ativan withdrawal from 1 mg - happens you overdose ativan

Anonymous said...

lorazepam online ativan addiction and withdrawal - lorazepam 1 mg tablet

Anonymous said...

ambien for sale ambien no prescription overnight delivery - quitting ambien cr cold turkey

Anonymous said...

buy soma what is carisoprodol dosage - carisoprodol recreational dose

Anonymous said...

buy ambien online ambien sleepwalking lawsuit - ambien sleepwalking 2010

Anonymous said...

valium cost valium on standard drug test - valium vs. xanax vs. klonopin vs. ativan

Anonymous said...

buy soma carisoprodol 350 mg street name - soma intimates online coupons