i use show status command to calculate the size of a table but i cant seem to find an option to calculate the table size in oracle i tried select sum(bytes)/1024/1024 from 'table_name'; but this did not workr i can calculate the size of the whole database with select sum(bytes)/1024/1024 from dba_extents; do you know a solution. -- .---. / . \ |\_/| | | | /| .----------------------------------------------------------------' | / .-.C++ Nurullah Akkaya Search| | / \ [EMAIL PROTECTED] | | |\_. | Registered Linux User #301438 | |\| | /| "What lies behind us and what lies before us are tiny | | `---' | matters compared to what lies within us." | | | Oliver Wendell Holmes | * | |MySql Engines/ | |-----------------------------------------------------------' \ | \ / `---'
-- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list