ReSizing the Bigfile Tablespace

SQL> alter tablespace bigts resize 4m;

Note : this command is only applicale for Bigfile tablespaces not for small tablespaces.

SQL> alter database datafile

                '/u02/app/oracle/ssss/venu1.dbf'

                resize 4m;

note : we need to alter the database if we want to resize the small tablespace datafiles.