Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Undo Table TableSpace Datafile
On Mon, 16 Apr 2007 16:50:34 -0400, Mikail Dellovich <foo_at_foo.com>
wrote:
>I have an Undo Table TableSpace Datafile that has grown to 17G. Right
>now only 11M are in use. How can I shrink this tablespace datafile down
>to 200M? I am on a Unix system. I tried to create a second undo datafile
> and then offline the other to remove. That would no go through
>because (I presume) because of the 11M still in the 17G file.
>
>What is the best way to reclaim the 17G of disk space back?
>
>Please help, thanks.
>
>Thanks
You have two options:
1 resize the original datafile using alter database datafile resize
2 create a new undo tablespace, point the database to the new undo
tablespace, and drop the old one, including contents and datafiles.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Apr 16 2007 - 16:01:30 CDT