!!! FIRST ACTION: DROP ALL OBJECTS FROM THE TABLESPACES TO BE SHRINKED (OR SAVE THEM VIA EXPORT BEFORE) !!!
______________________________________________________________________________________________________________

COLUMN name FORMAT A70
SELECT name, bytes/1024/1024 AS size_mb FROM v$datafile
WHERE name like '%aq_adm%'
   OR name like '%archiv%'
   OR name like '%betrfpl%'
   OR name like '%transfer%'
 ORDER BY 1;

NAME                                                                      SIZE_MB
---------------------------------------------------------------------- ----------
/app/orcl/oradata/ORCL/datafile/o1_mf_aq_adm.dbf                              850
/app/orcl/oradata/ORCL/datafile/o1_mf_archiv.dbf                             9196
/app/orcl/oradata/ORCL/datafile/o1_mf_archiv_i.dbf                          21930
/app/orcl/oradata/ORCL/datafile/o1_mf_betrfpl.dbf                           10750
/app/orcl/oradata/ORCL/datafile/o1_mf_transfer.dbf                          10865
______________________________________________________________________________________________________________

SELECT 'ALTER DATABASE DATAFILE ''' || name || ''' RESIZE 10M; ' "RESIZE_DATAFILES" FROM v$datafile
WHERE name like '%aq_adm%'
   OR name like '%archiv%'
   OR name like '%betrfpl%'
   OR name like '%transfer%'
 ORDER BY 1;

RESIZE_DATAFILES
-------------------------------------------------------------------------------------------
ALTER DATABASE DATAFILE '/app/orcl/oradata/ORCL/datafile/o1_mf_aq_adm.dbf' RESIZE 10M;
ALTER DATABASE DATAFILE '/app/orcl/oradata/ORCL/datafile/o1_mf_archiv.dbf' RESIZE 10M;
ALTER DATABASE DATAFILE '/app/orcl/oradata/ORCL/datafile/o1_mf_archiv_i.dbf' RESIZE 10M;
ALTER DATABASE DATAFILE '/app/orcl/oradata/ORCL/datafile/o1_mf_betrfpl.dbf' RESIZE 10M;
ALTER DATABASE DATAFILE '/app/orcl/oradata/ORCL/datafile/o1_mf_transfer.dbf' RESIZE 10M;
______________________________________________________________________________________________________________


 
NAME                                                                      SIZE_MB
---------------------------------------------------------------------- ----------
/app/orcl/oradata/ORCLDB/datafile/o1_mf_aq_adm.dbf                            450
/app/orcl/oradata/ORCLDB/datafile/o1_mf_archiv.dbf                           8700
/app/orcl/oradata/ORCLDB/datafile/o1_mf_archiv_i.dbf                        29100
/app/orcl/oradata/ORCLDB/datafile/o1_mf_betrfpl.dbf                         21400
/app/orcl/oradata/ORCLDB/datafile/o1_mf_transfer.dbf                         3950