To find out a size of a table in Megabytes use below SQL select segment_name,(bytes)/1024/1024 MB
2 from user_segments where
3 segment_type = 'TABLE'
4* and SEGMENT_NAME='TABLE_NAME'
Friday, October 31, 2008
Size of a Table
Posted by
AJ
at
6:36 PM
Labels: Table size
Subscribe to:
Post Comments (Atom)
Search
Categories
- Database Upgrade (1)
- Installation (1)
- Ora-12514 (1)
- Rollback Segments (1)
- Table size (1)
- TNSNAMES (1)
- Undo (1)
0 comments:
Post a Comment