Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> rollback segments
I do an import through an application which uses a plsql to load data to
a table. I have four RBS with small extents and one big one with large
extent. During load application guy called me and said he had this error
doing the load. ora- 1562 - failed to extend RBS number 4 ORA 1628-max
extent reached on RBS R03. The buble on his window stopped. I made the
big one online and made all the small ones offline and asked the guy to
run the job again. Nohting was happening and no error - Then I made all
of them online and the bubble started to move meaning load was working.
I dont know for 7900 rows to load why the big RBS (44.03 mb) was not enough. any one has suggestions. Received on Wed Apr 07 1999 - 17:42:45 CDT