Is it possible to shrink a datafile? The scenario is as such - after a few
months we have seen that our live tables are not going to grow anymore as we
archive data to an archive database. We initially set the tables to a large
initial extent but have dropped and imported them to new smaller tables. We
have a lot more free space available in the tablespace but this is not
needed.
Is it possible to reclaim this space in the physical file system by
shrinking the .dbf datafile???
Thanking you in advance
Andre
Received on Tue Aug 03 1999 - 06:09:00 CDT
