Q:I would like to know when it work with auto extend?
A: When it exceeds 100M then automatically added up 100M itself. Therefore autoextend begins to work after 100M in auto extend.
But when I check size in datafile, current size is 4800MB, and free is only 38M
why it doesn't auto extend automatically?
Send me ur comment of create datafile and to determine whether a datafile is auto-extensible, query the DBA_DATA_FILES view and examine the AUTOEXTENSIBLE column.
It still has free space. It will autoextend when it runs out of free space in the current size.
Hemant K Chitale