Managing Tablespaces

Create Tablespace 

 CREATE TABLESPACE CAR_DATA_01 DATAFILE '/oradata/CAR_DATA_01_01.dbf' SIZE 10M AUTOEXTEND ON MAXSIZE 20G;

--ASM--
CREATE TABLESPACE CAR_DATA_01 DATAFILE '+DATA' SIZE 1M AUTOEXTEND ON NEXT 500K MAXSIZE 10G;

Add Datafile

 ALTER TABLESPACE CMDC_SMALL_DATA01 ADD DATAFILE '/u02/app/oracle/oradata/CMDCPREP/CMDC_SMALL_DATA01_4.dbf' SIZE 1M AUTOEXTEND ON NEXT 500K MAXSIZE 30G;

--ASM--
 ALTER TABLESPACE CAR_DATA_DATA01  ADD DATAFILE '+DATADG' SIZE 1M AUTOEXTEND ON NEXT 500K MAXSIZE 10G ;


Increase MAXSIZE

--Find datafiles--
SELECT FILE_NAME,BYTES/1024/1024/1024,MAXBYTES/1024/1024/1024 FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'CAR_DATA_DATA01';

ALTER DATABASE DATAFILE '/u02/app/oracle/oradata/CAR_DATA_DATA01.dbf' AUTOEXTEND ON MAXSIZE 21G;


Move Tablespace/Datafile

ALTER TABLESPACE CAR_DATA_DATA OFFLINE;

cp CAR_DATA_DATA.DBF /NEWPATH/ORADATA/

ALTER DATABASE RENAME FILE '/oldpath/CAR_DATA_DATA.dbf'
TO '/newpath/oradata/CAR_DATA_DATA.dbf';

ALTER TABLESPACE CAR_DATA_DATA ONLINE;

**You can apply same scenario for move or rename datafile.