alexander-r
2/20/2020 - 10:49 PM

Oracle add datafile to tablespace

SELECT FILE_NAME, BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'USERS';

ALTER TABLESPACE USERS ADD DATAFILE 'E:\SOFTWARE\ORACLE\ORADATA\MRC2ORCL\USERS02.DBF' SIZE 2G AUTOEXTEND ON NEXT 100M;