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?