Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback tablespace question
If using 7.2 and above, resize the datafiles to a smaller size.
In article <72pl2e$v6c$1_at_news3.infoave.net>,
"Larry Schenavar" <schenavar_at_northstate.net> wrote:
> Hello.
>
> I have a tablespace that I set up for rollback segments. At the conversion
> stage of my project I had to make the tablespace large. Now that I'm in
> production the tablespace is oversized. What is the least impact way
> re-size the tablespace.
>
> -- Thanks in advance.
>
> ==============================
> Larry Schenavar
> Infrastructure Specialist /DB
> Electronic Data Systems, Inc
>
> Email: schenavar_at_northstate.net
> ==============================
>
>
--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 16 1998 - 20:33:27 CST