how can i increase rollback segments simultaneously??

From: <ashesh48_at_my-dejanews.com>
Date: Tue, 29 Dec 1998 14:46:38 GMT
Message-ID: <76aq0e$m45$1@nnrp1.dejanews.com>

Hi all, I am running v7.3.3 on NT 3.51 and i when i was refreshing the database i ran into the problem with rollback segments. i have 17 segments and of then 10 is online and when i was loading one segments has reached to 100mb and another has reached to 25 mb!!! which has used my 90% of total table_space for the rollabck segment. Is there any way that i can increase the size of all segments simultaneously OR can i move to another segment insteaad of only increasing the single segment. and how can i refresh the high water mark??

Thanks for any input in advance.
Ashesh

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 29 1998 - 08:46:38 CST