Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> rollback segments

rollback segments

From: Naushi Hussain <Naushi.Hussain_at_Alliedsignal.com>
Date: Wed, 07 Apr 1999 15:42:45 -0700
Message-ID: <370BDF65.841B17B9@Alliedsignal.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US