Flashback Query

ORA-08180: no snapshot found based on specified time

Size info

SQL> SELECT TABLESPACE_NAME, 'GB'||' '||ROUND(SUM(BYTES/1024/1024/1024)) "USED_SIZE" FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME;
SQL> SELECT TABLESPACE_NAME, 'MB'||' '||ROUND(SUM(BYTES/1024/1024)) "USED_SIZE" FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME;

SQL>
column file_name format a20;
select file_name,round(bytes/1024/1024/1024,1) Gb from dba_data_files where tablespace_name='UNDOTBS1';

Increase, extend

SQL> ALTER DATABASE DATAFILE '/u02/MONITOR/datafile/undotbs01.dbf' resize 12G;

Read Flashback Query (from tables and the undo segments)

SQL> SELECT … AS OF TIMESTAMP …