I had posted this earlier to PL/SQL category. I will delete from there ... sorry
ERROR Details :
While loading (full replace) data through sqlldr to table getting the bellow error.
The cron loading data to other tables at the same time, but loading failing only for this table.
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table CP_NC3_SITE_2
ORA-01562: failed to extend rollback segment number 1
ORA-01628: max # extents (121) reached for rollback segment TMP_RBS
Is it safe to execute the bellow command to resolve this error ?
If not then what need to be done , I have very little knowledge on DBA ... please assist ...
ALTER ROLLBACK SEGMENT TMP_RBS STORAGE (MAXEXTENTS 200);
Some Details which you may require -
SQL> SELECT tablespace_name, SEGMENT_NAME, INITIAL_EXTENT, NEXT_EXTENT, MAX_EXTENTS from dba_rollback_segs where SEGMENT_NAME='TMP_RBS';
TABLESPACE_NAME SEGMENT_NAME INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS
------------------------------ ------------------------------ -------------- ----------- -----------
SYSTEM TMP_RBS 16384 16384 121
SQL> SELECT tablespace_name, SEGMENT_NAME, INITIAL_EXTENT, NEXT_EXTENT, MAX_EXTENTS from dba_rollback_segs;
TABLESPACE_NAME SEGMENT_NAME INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS
------------------------------ ------------------------------ -------------- ----------- -----------
SYSTEM SYSTEM 51200 51200 121
SYSTEM TMP_RBS 16384 16384 121
SYSTEM CSMIP1_TEMP 10240 10240 121
CSMIP1_RBS CSMIP1_RBS01 4194304 4198400 1024
CSMIP1_RBS CSMIP1_RBS03 4194304 4198400 1024
CSMIP1_RBS CSMIP1_RBS04 4194304 4198400 1024
CSMIP1_RBS CSMIP1_RBS02 4194304 4198400 1024
CSMIP1_RBS RBS_S1 2097152 2099200 1024
CSMIP1_RBS RBS_S2 2097152 2099200 1024
CSMIP1_RBS RBS_S3 2097152 2099200 1024
CSMIP1_RBS CSMIP1_RBS05 4194304 4198400 32765
CSMIP1_RBS CSMIP1_RBS06 4194304 4198400 32765
CSMIP1_RBS CSMIP1_RBS07 4194304 4198400 32765
CSMIP1_RBS CSMIP1_RBS08 4194304 4198400 32765
14 rows selected.
SQL> show parameter rollback
NAME TYPE VALUE
------------------------------------ ------- --------------------
fast_start_parallel_rollback string LOW
gc_rollback_locks string 0-1024=32!8REACH
max_rollback_segments integer 122
rollback_segments string csmip1_rbs01, csmip1
transactions_per_rollback_segment integer 5