Yes, it is true becuase, oracle does not allocate contiguous memory blocks. If the occupied block is just near the end, then shirnking the file does not really shrink. So, only the option will be export, recreate the tablespace and import with the right storage parameters.




Reply With Quote