-
could you please tell me how to find out the SIZE OF A TABLE.(QUERY)
Thanks
Ravi
ravi
-
user the dba_segments view.
Hail Oracle !
-
table size
can u give me the query to find the size of a table
thanks
ravi
ravi
-
-
figured out
hey guys
u can use this query to find out the size of a table:
select owner||'.'||segment_name Segment_Name
, segment_type "Segment Type"
, sum(bytes)/1024/1024 "Size In MB"
from dba_segments
group by owner||'.'||segment_name
, segment_type;
Ravi
ravi
-
When i try to log into SQLplus, i get logged on with an error to run the PUPBLD script. I have run that script twice already as sys and still get the error message. When i query any table, i get an error that the table or view does not exist. When i query the same views in svrmgr, the statement is processed.Please help explain.
mane
-
Hi
you run pupbld.sql as SYSTEM not as SYS
The size of a table you need to analyze the table first to get the statistics and query dba_tables
num_rows* avg length (or smth I forgot thisa column name)
querying dba_segments is a wrong choice
-
[url]http://www.oracle.com/oramag/code/tips2000/Tip1.html[/url]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|