How to decrease the datafile size
360534May 24 2004 — edited May 24 2004Hi,
My datafile size of athe user tablesable has increased to 15 GB. On deleting rows worth 5 GB the datafile size still shows the size as 15 GB. I tried the RESIZE commad but it doesn't allows to change it, giving the error that file contains data beyond the RESIZE value. I tried the COAELSE command also but to no effect.
I also cannot try any option which result in making the DB Server down.
Thanks,
Tuhin