Oracle tablespace

 select tablespace

create tablespace

CREATE TABLESPACE tbs_01 DATAFILE 'tbs_f2.dbf' SIZE 40M     ONLINE;

ONLINE  Specify ONLINE to make the tablespace available immediately after creation to users who have been granted access to the tablespace. This is the default.

OFFLINE  Specify OFFLINE to make the tablespace unavailable immediately after creation.

CREATE TEMPORARY TABLESPACE tablespace_name
TEMPFILE Tempfile_Options
[EXTENT MANAGEMENT LOCAL]
[UNIFORM [SIZE int K | M] ];



ALTER TABLESPACE tspace ADD ADD DATAFILE
'c:\oracle\product\oradata\testbed.dat' SIZE 10M
AUTOEXTEND ON;


SELECT table_name
FROM dba_tables
WHERE tablespace_name = 'SALES_DATA';



ALTER TABLESPACE sales RENAME TO sales_data;

SELECT tablespace_name
FROM dba_tablespaces;


SELECT file_name, tablespace_name, ROUND(bytes/1024000) MB
FROM dba_data_files
ORDER BY 1;