How to know the size of the table we created?

Showing Answers 1 - 3 of 3 Answers


 SELECT BYTES/1024

    FROM DBA_EXTENTS

 WHERE OWNER = 'SCOTT'

      AND SEGMENT_NAME = 'EMP';

  This will return you size of table in Kilo Bytes.
  User is Scott and Table is Emp.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions