Re: Rollback tablespace question

Hi there

You didn't tell what version of Oracle you're using?

If it's 7.3 or larger, you should be able to do the following in order to decrease the file size of your rollback tablespace:

alter database <database name> datafile '<datafilename>' resize <new-size>;

F.ex:

alter database axap datafile 'c:\orant\database\rbs01.ora' resize 150M;

P.S. The above only holds as long as the rollback segments aren't in use, beyond the size you wish to resize to (or has framents overlapping the new size).

--
Yours,

Morten Toftgaard Jensen
Aalborg, Denmark
mtj_at_stofanet.dk

Larry Schenavar wrote in message <72pl2e$v6c$1_at_news3.infoave.net>...
>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
>==============================
>
>
Received on Mon Nov 16 1998 - 14:55:12 CST