970946 wrote:That's scary in itself. You are "only" 7 generations out of support. Is your OS equally ancient? Your hardware?
We run Oracle 8.0.3 in a Sun computer with Solaris 5.8.
Recently we had a severe error in our application because one of the oracle tablespaces reached the 2Gb size limit (O.S. max file size).That's not a max size for the TS, just for one data file. You could have simply added another file to the TS ......
Now we need to shrink the tablespace and free O.S. disk space, because the application cannot write anymore in the database.
We have deleted all the records of one of the tables, which is the biggest table in the tablespace and contains log information. This table has lots of indexes.
Please, could someone give precise instructions in order to be able to reduce the phisical size of the tablespace?
I have read dozens of threads about tablespace shrinking, but I have not found a good/detailed solution for Oracle 8.0.3
I really appreciate any help in this issue.