ORA-02478: merge into base segment would overflow MAXEXTENTS
limit



ORA-02478: merge into base segment would overflow MAXEXTENTS limit..

Answer / guest

Cause: Merge of temporary segment into base segment failed
because MAXEXTENTS was larger than the total in the temp and
base segments

Action: Use a larger value for MAXEXTENTS on the base
segment or make the extents in the temporary segments larger

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09881: sstasfre/sstasdel: shmdt error, unable to detach tas read page

1 Answers  


TNS-12527: TNS:listener: all instances are in restricted mode or blocking new connections

1 Answers  


ORA-28560: error in configuration of agent process

1 Answers  


ORA-31524: could not find change set string for CDC change table string.string

1 Answers  


LPX-00209: PI names starting with XML are reserved

1 Answers  






NZE-28755: object retrieval failure

1 Answers  


ORA-09794: szrbuild: length of role name is greater than buffer.

1 Answers  


ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

1 Answers  


RMAN-06107: WARNING: controlfile is not current for REPORT NEED BACKUP DAYS

1 Answers  


RMAN-06023: no backup or copy of datafile number found to restore

1 Answers  


ORA-30745: error occured while trying to add column "string" in table "string"

1 Answers  


ORA-21301: not initialized in object mode

1 Answers  


Categories