Tablespace Reorg- Reduced free space not reflecting at OS HP-UX

[Former Member]

Hi,

I have Followed the procedure in SAP Note: 646681(Section IV) to

perform a Tablespace Reorg. I have choosed PSAPBTABD & PSAPBTABI for

Reorg and completed Successfuly. The DB Size of 1.6TB was reduced to

1.3 which released the free space of 363GB from the Database. I Could

see the difference in Size at DB02(SAP Level), But it is not reflecting

at OS level(HP-UX) after droping the old Tablespace. Tablespace became

99%. All filesystems shows full when "bdf" executed. Please Advice.

Thanks

Prasad

[markus_doehr2]

Did you drop the tablespace including the datafiles? Or are they still there?

Markus

[Former Member]

Yes i dropped the datafiles also along with Tablespace. I have restarted Oracle at SQL level which unmounted the database and mounted again which fixed the issue.

Thanks

Prasad