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 -> Re: Undo Table TableSpace Datafile

Re: Undo Table TableSpace Datafile

From: <sybrandb_at_hccnet.nl>
Date: Mon, 16 Apr 2007 23:01:30 +0200
Message-ID: <3uo723drlseqcu5rfcjkbmmk8r1thdbg44@4ax.com>


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 DBA
Received on Mon Apr 16 2007 - 16:01:30 CDT

Original text of this message

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