ORA-01630: max # extents (string) reached in temp segment in
tablespace string



ORA-01630: max # extents (string) reached in temp segment in tablespace string..

Answer / guest

Cause: A temp segment tried to extend past max extents.

Action: If maxextents for the tablespace is less than the
the system maximum, you can raise that. Otherwise, raise
pctincrease for the tablespace

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13208: internal error while evaluating [string] operator

1 Answers  


TNS-00259: Disabled Interchange list:

1 Answers  


SQL*Loader-00957: Error shipping text string across 2-task

1 Answers  


ORA-09214: sfdone: I/O error detected

1 Answers  


PCB-00301: Use of non-ANSI function is an Oracle extension

1 Answers  






QSM-00772: the specified SQL statement cannot be stored in the workload due to a statement error

1 Answers  


ORA-28026: user with same external name already exists

1 Answers  


ORA-19694: some changed blocks were not found in the change tracking file

1 Answers  


ORA-02780: Name given for the core dump directory is invalid

1 Answers  


ORA-02042: too many distributed transactions

1 Answers  


ORA-39708: component 'string' not a string component

1 Answers  


ORA-16108: database is no longer a standby database

1 Answers  


Categories