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

RMAN-08117: channel string: the autobackup does not contain an SPFILE

1 Answers  


PLS-01503: The expression in a SET clause must not include a set function

1 Answers  


ORA-32737: Hang analysis aborted due to failed memory allocation

1 Answers  


KUP-11012: file string in string already exists

1 Answers  


ORA-39032: function string is not supported in string jobs

1 Answers  






ORA-14280: all rows in table do not qualify for specified subpartition

1 Answers  


ORA-36686: (XSDPART24) Value number is not in partition number.

1 Answers  


TNS-01305: nt main err code: number

1 Answers  


ORA-08457: syntax error in SEPARATE CHARACTER option of SIGN clause

1 Answers  


ORA-30509: client logoff triggers cannot have AFTER type

1 Answers  


SQL*Loader-00487: COUNT clause required for collection string

1 Answers  


RMAN-06007: target database not mounted and db_name not set in init.ora

1 Answers  


Categories