Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
You can use Undo Advisor to set UNDO_RETENTION and the required undo tablespace size. You can open the Undo Advisor using the Database-> Diagnose-> …
Read More »Tag Archives: undo tablespace
ORA-01555 Snapshot Too Old / ORA-30036: unable to extend segment by string in undo tablespace
ORA-01555 Snapshot Too Old The “ORA-01555 Snapshot Too Old” error usually comes in long-running queries. In Oracle, previous changes of the data are retained in …
Read More »How To Create Tablespace On Oracle
Tablespaces are areas dedicated to storing objects in the database. Tablespaces are logical constructs. However, it contains physical data files or temp files. There are …
Read More »