AUTOEXTEND

How to Resolve ORA-00933: SQL command not properly ended

by Ed Chen
September 22, 2021February 20, 2023

ORA-00933 ORA-00933 means that you use an unexpected word or phrase at the position where SQL parser knows what qualified keyword should be. Use cases… Read More »

How to Resolve ORA-01555 UNDO_RETENTION

by Ed Chen
April 8, 2016December 11, 2022

ORA-01555 UNDO_RETENTION Let's see the error ORA-01555 UNDO_RETENTION first: Description ORA-01555: snapshot too old: rollback segment number string with name "string" too small Cause rollback… Read More »

How to Resolve ORA-30036 UNABLE TO EXTEND SEGMENT BY 8 IN UNDO TABLESPACE 'UNDOTBS1'

by Ed Chen
October 19, 2012December 11, 2022

ORA-30036 This error ORA-30036 could be very serious in a situation that is described below and may make users panic: One day, a DBA was… Read More »

How to Resolve ORA-01653 Unable to Extend Table in Tablespace

by Ed Chen
October 18, 2012December 15, 2022

ORA-01653 The following two error messages are very similar. As a DBA, you'll probably meet them someday in the future. ORA-01653 is for table, ORA-01654… Read More »