5 Replies Latest reply: Apr 5, 2013 7:01 PM by marksmithusa RSS

    What happens if AUTOEXTEND is ON and datafile reaches the limit?

    1001046
      Hi,

      I´m using Oracle 11g. I have created a tablespace using the following command:

      CREATE TABLESPACE MYTABLESPACE
      DATAFILE '<PATH>'
      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.


      Thank you,