Based on your output, i see 3 tablespaces with 2gb of size Add more space to the undo tablespace before retrying the operation Perhaps one of them is the default assigned undo and auto extend is off.
Best 10 femboy aka bibblekittyyyy – Artofit
Unable to extend segment by 8 in undo tablespace 'undotbs'
Does increasing the tablespce is the only solution for this issue and how to do that?
Unable to extend segment by string in undo tablespace ‘string’ The specified undo tablespace has no more space available Add more space to the undo tablespace before retrying the operation. Unable to extend segment by 8 in undo tablespace” error message in oracle databases indicates that the undo tablespace has run out of space and can’t be extended to accommodate the additional undo data that needs to be generated.
This indicates that rollback was being performed during the time in which no progress was made It appears there is excessive undo being generated To view full details, sign in with your my oracle support account Don't have a my oracle support account
That said, if the link provided by @mustaccio doesn't help (and it sounds like it should help), the answer to growing a tablespace limited to 32gb per file is simply to add another file using the alter tablespace command.
Sign up to request clarification or add additional context in comments.
