Horje
query to find table size in oracle 12c Code Example
query to find table size in oracle 12c 
SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs
FROM dba_extents e
WHERE
  e.OWNER = 'SCHEME_NAME' AND
  e.TABLESPACE_NAME = 'TBS_NAME' AND
  e.SEGMENT_NAME IN ('TABLE_NAME')
GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME
ORDER BY e.TABLESPACE_NAME, e.SEGMENT_NAME;



Sql

Related
mysql print variable Code Example mysql print variable Code Example
how to remove unique key constraint in mysql Code Example how to remove unique key constraint in mysql Code Example
sql server alter table column nullable Code Example sql server alter table column nullable Code Example
mysql find most common value Code Example mysql find most common value Code Example
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue. Code Example The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue. Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje