Groovy DBA

 ORA-01187: cannot read from file  because it failed verification tests ORA-01110: data file 3001: '/usr/opt/app/oracle/admin/gentest3/temp01/temp01.dbf' ORA-06512: at "SYS.DBMS_LOB", line 741 ORA-06512: at "SYS.DBMS_DATAPUMP", line 5420 ORA-06512: at line 1 SQL> select FILE#,NAME  from  v$tempfile;      FILE# ---------- NAME --------------------------------------------------------------------------------          1 /usr/opt/app/oracle/admin/gentest3/temp01/temp01.dbf SQL> SELECT PROPERTY_VALUE   FROM DATABASE_PROPERTIES  WHERE PROPERTY_NAME = 'DEFAULT_TEMP_TABLESPACE'; PROPERTY_VALUE -------------------------------------------------------------------------------- TEMP SQL> ALTER TABLESPACE temp ADD TEMPFILE '/usr/opt/app/oracle/admin/gentest3/temp01/temp02.dbf' size 10M; Tablespace altered. SQL> ALTER DATABASE TEMPFILE '/usr/opt/app/oracle/admin/gentest3/temp01/temp01.dbf' DROP INCLUDING DATAFILES; D...

select segment_name,sum(bytes)/1024/1024/1024 GB from dba_segments where segment_type='TABLE' and segment_name=upper('&TABLE_NAME') group by segment_name;