Question regarding auto extend tablespace
I created the following tablespace:
CREATE TABLESPACE "SIREPO" DATAFILE '/dsk01/oradata/sirepo01.dbf' SIZE 100M AUTOEXTEND ON MAXSIZE 10000M extent management local uniform size 5M segment space management auto;
Does this mean by tablespace can go to 10g the max?
I later added some more datafiles under this tablespace,
alter database datafile '/dsk01/oradata/sirepo02.dbf' autoextend on maxsize 10000M;
alter database datafile '/dsk01/oradata/sirepo03.dbf' autoextend on maxsize 10000M;
alter database datafile '/dsk01/oradata/sirepo04.dbf' autoextend on maxsize 10000M;
Does this mean each of the datafile within the tablespace will be able to autoextend up to 10G?