Hello,

I am executing one sql file which populates our tables in database from other schema. My sql file contents are as follows.
Each procedure populates one table.

begin
set transaction use rollback segment BIG_R01;
-- EOD tables will be populated here
PKG_REP_EOD.prc_princ_co_share_hist;
PKG_REP_EOD.prc_unalloc_share_balances;
PKG_REP_EOD.prc_distribution_percentages;
PKG_REP_EOD.prc_company_trusts;
pkg_rep_eod.prc_historic_share_price;
end;
/

Evenif I am assigning big rollback segment why its giving following error.

ORA-01562: failed to extend rollback segment number 5
ORA-01628: max # extents (500) reached for rollback segment R04

Thanks

Paresh