Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Friday, December 16, 2005

Get Table Size

Just run the query given below to get the size of a table in MB.

SQL> conn scott/tiger@IUB

SQL> SELECT bytes/1024/1024 MB 2 FROM USER_segments 3* WHERE segment_name = UPPER('&tn')

Enter value for tn: EMP
old 3: WHERE segment_name = UPPER('&tn')
new 3: WHERE segment_name = UPPER('EMP')


No comments: