What happens if auto extend is enabled and the datafile allocated space is larger than its max size
One of our tablespaces has auto extend enabled and has a datafile with allocated space that is larger than the max size, see data.dbf. I assume someone manually increased the allocated space to create this situation. Will auto extend still function? I see that data2.dbf has 0 free space but it has not even gotten close to it's max size. Is the situation with data.dbf impacting the auto extend for data2.dbf?
Did this situation break anything? Can I increase the max size of data.dbf to make it larger than the allocated size? Would that fix any issues that this might have caused?