This content has been marked as final. Show 5 replies
998043 wrote:File stops expanding & error is thrown.
I´m using Oracle 11g. I have created a tablespace using the following command:
CREATE TABLESPACE MYTABLESPACE
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
The datafile is almost full. The question is: given that AUTOEXTEND is ON, will a new datafile be created automatically when the original datafile reaches the limit? (datafile is SMALLFILE)
I would appreciate your help.