Re: shrink tablespace on 9i
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Fri, 17 Aug 2007 11:37:39 +0300
It is possible to complete without full exp/imp in 9i but it is a
little bit tricky tasks.
You need to move all free space you have in a tablespace to the end of
data file.
To do that you can create additional tablespace move all objects to
that one then move objects back.
After ther use alter database datafile 'XXX' rezise YYY MB; to the
value allowed.
To move tables use "alter table move" for indexes "alter index rebuild".
For queues tables/indexes you need to drop and rebuild queues
(temporary storing active messages in other queues).
Not easy but possible to accomplish.
Good luck,
J.
On 8/17/07, Kenan Öztürk <mynameiskenan@xxxxxxxxx> wrote:
> Hi all,
>
> question about database maintenance?
>
> is it possible to shrink tablespace on 9i, is there any command to do that
> or ony way to do this is export/import tablespace?
>
> Regards
>
>
> ________________________________
> Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,
> news, photos & more.
>
>
--
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
