This discussion is archived
5 Replies Latest reply: Apr 5, 2013 5:01 PM by marksmithusa RSS

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

1001046 Newbie
Currently Being Moderated
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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points