Database Backup and Recovery (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center