ORA-01555 Error

Hello, how much is the tablepace size ? Connect to sqlplus from your terminal than run this sql commands. SELECT d.undo_size/(1024*1024) as UNDO_SIZE, SUBSTR(e.value,1,25) as UNDO_RETENTION, ROUND((d.undo_size / (to_number(f.value) * g.undo_block_per_sec))) as OPTIMUM_UNDO_RETENTION FROM ( SELECT SUM(a.bytes) undo_size FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = ‘UNDO’ AND c.status = ‘ONLINE’ AND b.name […]