Re: Rollback tablespace question

Two options come to mind:

(1) if your tablespace was created on 1 large datafile, you could use the

     alter tablespace <rollback_tablespace>
     resize datafile 'datafile_name' <new_size>;

(2) temporarily create another tablespace with a few small rollback segments in it, bring them online, take the "real" ones offline and drop them, then recreate the rollback tablespace with the size you want, bring the new segments online, then drop the temporary one.

HTH 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
> ==============================
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 16 1998 - 14:29:45 CST