SELECT v.file#, t.file_name, v.status
FROM dba_temp_files t, v$tempfile v
WHERE t.file_id = v.file#;

ALTER TABLESPACE "TEMP"
    ADD TEMPFILE 'C:\ORACLE\ORADATA\DBT\TEMP02.DBF'  SIZE  1000M;


select file_id,file_name,bytes from dba_data_files where tablespace_name='EXAMPLE';

ALTER TABLESPACE "EXAMPLE"
    ADD
    DATAFILE 'C:\ORACLE\ORADATA\DBT\EXAMPLE02.DBF'  SIZE  1000M
    REUSE AUTOEXTEND
    ON NEXT  640K MAXSIZE  32767M;

ALTER DATABASE
    DATAFILE 'C:\ORACLE\ORADATA\DBT\EXAMPLE02.DBF' RESIZE  500M;

ALTER DATABASE
    DATAFILE 'C:\ORACLE\ORADATA\DBT\EXAMPLE02.DBF' AUTOEXTEND
    ON MAXSIZE  5000M;

ALTER DATABASE
    DATAFILE 'C:\ORACLE\ORADATA\DBT\EXAMPLE02.DBF' AUTOEXTEND OFF;