Oracle: Tablespace Management

• Add datafile to normal tablespace

ALTER TABLESPACE DIAGRAM_INDEXES ADD DATAFILE '/dbfs/data5/DIAGRAM_INDEXES02.dbf' SIZE 200M REUSE AUTOEXTEND ON;

• Add datafile to temporarytablespace

ALTER TABLESPACE REPOS_TEMP ADD TEMPFILE '/dbfs/data5/REPOS_TEMP02' SIZE 200M REUSE AUTOEXTEND ON;
ALTER TABLESPACE REPOS_TEMP TEMPFILE OFFLINE;
ALTER TABLESPACE REPOS_TEMP TEMPFILE ONLINE;