Resizing Data file After Purging Data from Segment (Table Heap Organized)
Hi,
I've purged data from one of my og table which was about 10GB in size. After Purging data I've shrink that segment and it shrink successfully. Now the
table contains only 10-20 records and it will be size of few Kb. Now My question is after doing this activity why the size of datafile get not shrink i.e
before purging the size of datafile was of say 30 GB then after purging it should be around of 20 GB. I've tried to resize the data file but it gives me error
that datafile can't be resize beyond used extends. We have default Tablespace and this contain only single datafile.
Kindly help me in clearinig this ambugity.
Regards,
kamran