Tuesday, September 17, 2013

Table Size 

----------------------------------
- Tablespace Size
-File Name: tab_size.sql
-Usage: @tab_size
-----------------------------------

select BYTES/1024/1024 from dba_segments where segment_name='&table_size'
/
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

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