Reorganizing tablespace files
In case you are working with HD Space limit, for instance running Oracle XE, you should be aware of following procedure to reduce tablespace files. You may have tried to reduce datafile space with command:
1 |
alter database datafile 5 resize 1000M; |
And obtained error:
1 2 3 |
* ERROR at line 1: ORA-03297: file contains used data beyond requested RESIZE value |
In my case, I had an Oracle Xe 11g with big tablespaces (7 GB’s of […]