Import and Export the objects from that tablespace back again is your only
chance. If you have foreign keys ponting towards other tablespaces... then
you're skrewed.
Adrian Harrison wrote in message <37c11549.81624820_at_news.globalnet.co.uk>...
>Using Oracle 7.3.4
>
>I have a tablespace (size = 30 meg), that I've just deleted probably 90% of
the contents.
>
>Using the Navigator Tool that comes with Personnel Oracle the "Used Space"
& "Free Space" hasn't
>changed at all for this tablespace.
>
>All the deletions were definetely committed so what I'm wondering is if I'm
supposed to do some sort
>of "compact" to free this space up!
>
>Any ideas?
>
>Thanks
>
>Adrian Harrison
Received on Mon Aug 23 1999 - 07:47:52 CDT
