Tuesday, September 17, 2013

Tablespace Free Space

----------------------
-Tablespace Free Space
-ts_free.sql
-usage : @ts_free
----------------------

SELECT tablespace_name,SUM(bytes)/1024/1024 "Free in MB"
FROM dba_free_space where tablespace_name='&T_NAME' GROUP BY tablespace_name
/

1 comment:

NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL

Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. INST_TOP/adm...