All Oracle Error CodesOracle DBA Forum

ORA-03297:

file contains used data beyond requested RESIZE value
Cause: Some portion of the file in the region to be trimmed is currently in use by a database object
Action: Drop or move segments containing extents in this region prior to resizing the file, or choose a resize value such that only free space is in the trimmed.
 SubjectReplies
1. way to shrink temporary tablespace ??2
2.DWH loading : Do you use 2 types of tablespaces ?1