alter rollback segment

Hi,

I have a question about altering rollback segment (typically RBS01.DBF), Info: oracle info: 8.1.6r2 on Linux (SuSe 6.4)

Point is: after creating the 'create scripts' for a new database (and I ran them), the default rollback segment is about 500Mb, which is much too large in my opinion (although I'm not a DBA, just a developer). My older databases still have these huge rollback '.dbf' files, so I want to change them. Perhaps someone here also has a create script (with SID for argument and perhaps some other parameters) which create a 'good' database.

Question:
How do I set a new size (resize) for a rollback segment (when my database is stopped).

although I have the book 'Oracle Development Unleahsed', I was not able to find the proper statements, and the 'dbassist' command on Xwindows results in an ordinnary core dump (perhaps common in 8.1.6R2) when issuing 'change database'. It must have to do with:

"

alter rollback segment <name> offline;
blabla;
"

thnx in advance,
Michiel Received on Fri May 04 2001 - 15:10:49 CDT