All Oracle Error CodesOracle DBA Forum


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.
1. way to shrink temporary tablespace ??2
2.DWH loading : Do you use 2 types of tablespaces ?1