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')
MB----------
.0625
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment