Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Designer 9i Clean-up?

Designer 9i Clean-up?

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sat, 11 Mar 2006 19:46:34 GMT
Message-ID: <uOFQf.75071$PL5.68653@newssvr11.news.prodigy.com>


I have a Designer 9i repository on my home PC and noticed that the space used on a large number of my tablespaces are at 100% and a good number in the 90%s.

I've recently been doing a lot of work in Designer and have been deleting objects. I'm pretty sure there is space which could be reclaimed somehow.

Can I do something as simple as an export and then an import to clean-up the tablespaces? They're all autoextending but I'd still like to clean up any unused space if possible.

Thanks. Received on Sat Mar 11 2006 - 13:46:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US