Hi all
I have a database which is about 500GB in size, a tablespace for the
ROLLBACK which is 40GG with 20 rollback @ 780MB each, then we
introduce partition tables after about 2 weeks we start getting
"ORA-01555 rollback segment RBS1 too old, too small" I called oracle
support on this they are useless, they are just giving me notes to
read, which most of them do not apply (I have a data warehouse db). I
don't know what to do anymore? currently we are planning to hard code
a rollback to this job which fails, which drop and recreates a
partition table with 2 partitions, is there any issues with rollback
segments with partition tables? should I increase the rollback's from
20 to 30 rollback segments? any ideas would be great, I'm running out
of ideas as what to do next
Thanks
Maria
Received on Tue Jul 08 2003 - 20:52:31 CDT
