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