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...
undo
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_...