Yet another question... you must be thinking by now that all we do is get stuck but I assure you a lot of work goes smoothly but you just don't get to hear about it
Anywho.. I noticed today that I am again running out of space on the server where my Oracle DB resides so I decided to delete some old archive sets to free up some physical space. To my surprise, no HD space became available when I did this using the Backup/Restore panel, a little investigation revealed that the tables files are still there (although no longer shown in WinCC-OA) and I cannot figure out why they haven't been deleted.
I am using Oracle Enterprise 11g.. Also, I cannot see any tables in the Oracle recycling bin which is a feature that is annoyingly turned on by default from Oracle 10g onwards.
Any help/advice would be much appreciated as I have only 266MB left on my drive :unsure:
By the way, I tried using RDB compression which had the compete opposite effect to what I thought it would do... I had approximately 1GB left of HD space when I activated a 60min average compression for the roughly 4600 DPs in my system. I guess I didn't realise that would create the averages alongside the uncompressed data... by the time I managed to stop the calculation I was left with 266MB.
As my free disk space dropped to 4MB today, I desperately looked for a way shrinking tablespaces and came across a command that did just the trick;
ALTER DATABASE DATAFILE 'd:/DatabaseFiles/PVSSRDB/PVSSRDB_RAIN_00100069.dbf' RESIZE 20M;
My default table size was set to 500MB and as I was changing archive files on a weekly basis, I quickly ended up with a bunch of nearly empty database files, schoolboy error I guess. I resized all my existing tables and managed to free up as much as 20GB =)
I am now only swapping archive files when they reach their allocated size of 512MB.
I still haven't manage to resolve the mystery of tablespaces left behind when deleted though, any thoughts?
