undo

ORA-30033: Undo tablespace cannot be specified as default user tablespace

PROBLEM: While creating or altering a user with default tablespace got below error. SQL> alter user dba_raj default tablespace UNDOTBS1; alter user dba_raj default tablespace UNDOTBS1 * ERROR at li...

ORA-01203: wrong incarnation of this file – wrong creation SCN

PROBLEM: While opening a database, getting the error, ORA-01203: wrong incarnation of this file SQL> alter database open; alter database open * ERROR at line 1: ORA-01122: database file 4 failed ve...

Tablespace Management in oracle

What is a tablespace and datafile: Tablespace is the primary logic structure of the oracle database. It consists of one or more physical datafiles. Datafiles physical stores database data in storage.(...

How to find free space in UNDO tablespace

Use below script to get the details about undo tablespace usage.   select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB - USAGEMB) FREEMB from (select sum(bytes) / 1024 / 1024 SIZEMB, b.tablespace_...