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: Rollback tablespace question

Re: Rollback tablespace question

From: <satar_at_my-dejanews.com>
Date: Tue, 17 Nov 1998 02:33:27 GMT
Message-ID: <72qn9n$ln4$1@nnrp1.dejanews.com>


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

Original text of this message

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