Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to know the size change of a table under SQL*plus?
Hi,
I have problem with getting to know the size change of a table in bytes under SQL*plus. I tried using SELECT SEGMENT_NAME, BYTES FROM USER_SEGMENTS. I found the table name, the number of bytes. But after I deleted over 500 rows in that table, the number of bytes for the table still remained the same. I may need to use some other statements to know if a table's size changes. Would someone like to help me on this? I really appreciate it.
Thanks a lot.
Regard,
Lucy Received on Fri Aug 13 1999 - 12:43:09 CDT
![]() |
![]() |