ORA-23409: could not find an unused refresh group number

Question Posted / guest

1 Answers
3354 Views
I also Faced
E-Mail Answers

ORA-23409: could not find an unused refresh group number..

Answer / guest

Cause: 1000 consecutive refresh group numbers, as defined by
the rgroupseq number, were already used by rows in sys.rgroup$.

Action: Alter the sequence number to be within a legal
unused range and destroy unneeded refresh groups.

Please add more information about this Error

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00903: Pro*COBOL is unable to initialize its parser function

1 Answers

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

0 Answers HCL,

ORA-02403: plan table does not have correct format

2 Answers

ORA-12728: invalid range in regular expression

1 Answers

ORA-01674: data file string is an old incarnation rather than current file

1 Answers

IMG-00545: invalid cut values specified

1 Answers

ORA-13641: Task cannot be interrupted yet. You may cancel it instead.

1 Answers

SQL*Loader-00107: Invalid maximum number of discards