A data file can be associated with only one database. Once created a data file can't change size.One or more data files form a logical unit of database storage called a tablespace.

ranjithsv18

• Oct 2nd, 2013

Block size available from 2k,4k,8k,16k and 32k.

As per oracle point of view Default (or) standard block size is 8k for Data files.The initialization parameter

db_block_size=8k (8192)remaining size are non-standard blok size. Extents size 64k.

(Datafile

NAGARAJ OCP

• Dec 27th, 2011

In data files, we cant change the extent management, type of it. But we can change the storage space for it if we need after the database (tablespace) creation.

Answer Question  Select Best Answer