So, what I am trying to say is, perhaps there could be this feature, that along with the minimum size suggests also that this resize value is possbile only if recyclebin is purged. So the next step for me would be toĪfter that I managed to shrink datafile exactly as Toad suggested me. I couldn't figure this out at start, but then I was wondering, what if something is in recyclebin.
"ORA-03297: file contains used data beyond requested RESIZE value" When tried datafile shrinking feature inside Toad (Schema Browser -> Tablespaces -> (select single tablespace) -> Datafiles -> (select single datafile) -> Alter datafile -> Minimum Size?), then it, at start, actually allowed to shrink datafile (few hundred MB), but when I clicked "OK" from this dialog box, then I got ORA error: Although there (at the end of the datafile) were at least few hundred MB free space, but I couldn't resize this file even like 1MB. So recently I was stuck with shrinking USERS tablespace datafile.
0 kommentar(er)
