Re: ORA-01562 & ORA-01547 ERRORS

I read all the suggestions posted above. Every idea seems to be fine. Space allocation in Oracle is one of the major citical things. If you experience the problem maximum number of extents reached while deleting or doing any transactions you can think about using a private rollback segment. We create private rollback segments which are bigger in size then we call it for the transactions for which we need it. This makes sure that the RBS is fully dedicated to that particular transaction only.

For calling the private RBS use the command as the first statement of your sql

"SET TRANSACTION USE ROLLBACK SEGMENT rollback_segment_name;"

Gopal Vanamamalai
Oracle DBA
Fujitsu Network Communications, Inc
email: gvanamal_at_tddcae99.fnts.com Received on Wed Jul 24 1996 - 00:00:00 CEST