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

Reply via email to