ORA-02830: Segment could not be split - no free segments
available



ORA-02830: Segment could not be split - no free segments available..

Answer / guest

Cause: A segment that is larger than that desired could not
be split because no free segment was available.

Action: Free some segments and try again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02173: invalid option for DROP TABLESPACE

1 Answers  


ORA-12030: cannot create a fast refresh materialized view

1 Answers  


CLSR-00505: Empty event type is specified

1 Answers  


LFI-00126: Record format can only be one of Fixed or Variable.

1 Answers  


In VB program, I got message as " No Transaction is Active" , Backend database is Oracle, This message is coming some user's PC and Not all user's PC Please help me to resolve this issue

2 Answers  






ORA-01194: file string needs more recovery to be consistent

1 Answers  


NZE-29226: No matching private key found.

1 Answers  


TNS-00064: INTCTL: Failed to find CMANAGER_NAME in INTCHG.ORA

1 Answers  


ORA-31696: unable to export/import string using client specified string method

1 Answers  


ORA-06420: NETCMN: SID lookup failure

1 Answers  


ORA-13353: ELEM_INFO_ARRAY not grouped in threes

1 Answers  


ORA-08000: maximum number of session sequence lists exceeded

1 Answers  


Categories