Reclaiming sotrage On OS level
I have tablespace that reached 100GB i truncated the tbig tables and now all the size is 3GB when i try to shirnk the datafiles i get the error ORA-03297: file contains used data beyond requested RESIZE value
its somthing related to the high watermark but how can i restore the size and decrease the size of the tablespace
DB: RAC 19c version 19.3 OS: LINUX
below is information regarding the tablespace:
DB block size 8192
select file_name,bytes/1024/1024/1024 from dba_data_files where tablespace_name='TRANSIT_TS';
+DATAFILE/ENV3DB/AB7D156EC6966AF8E0530136960AAF03/DATAFILE/transit_ts.271.1047061613 31.9999847412109375
+DATAFILE/ENV3DB/AB7D156EC6966AF8E0530136960AAF03/DATAFILE/transit_ts.281.1063642741 31.9999847412109375