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.
