Friday, May 25, 2007

ORACLE. TABLESPACE restriction.

Interesting note:

If you'll try to create tablespace like this:

CREATE TABLESPACE "TSPACE" NOLOGGING
DATAFILE 'D:\TSPACE.ora' SIZE 6000M AUTOEXTEND ON NEXT 5M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

it would be failure operation due to it size. But 1Gb tablespace was created successful.
Does anybody know where this restriction is noted?

1 comment:

amaltsev-tech said...

If this question is interesting for you - come here:
http://www.sql.ru/forum/actualthread.aspx?tid=433341