Database Administration (MOSC)

MOSC Banner

oracle create tablespace without specify size question

edited Feb 5, 2010 2:00AM in Database Administration (MOSC) 6 commentsAnswered
in suse 10 , oracle 11g,

i just did a test,

create a 2G lv , raw the lv ( such as /dev/raw/raw16)

now create tablespace without specify size in this raw file,such

as

SQL> CREATE BIGFILE TABLESPACE test_big
           DATAFILE '/dev/raw/raw16' reuse;

command is ok, and select bytes from v$datafile ,check the size is 2147475456 (2147.99M),

my question is does this normal , i usually heared that thing , if datafile uesed  is lv , we must reserve 2M -10M size for LVM  management , but in our test , datafile use almost the 2G size (LV is 2G).does

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center