-
Solution to get count(*) from Big tables quickly
Oracle Version: Either 10g OR 11gR2
Objective: Finding total count(number of records) in each table under any schema.
Avoiding: trying to avoid count(*) OR referring num_rows in dba_tables (even if stats in on)
Tools: Either exp OR expdp
Questions
(1) Is there any way I could generate an Oracle export log file with number of records per table (exactly like our normal export log) WITHOUT actually exporting data?
(2) Or is there any suggestion to retrieve total number of records [ count(*)] from big tables quickly?
Please Note: BTW, I am aware of ESTIMATE_ONLY, but that is not what I am looking for.
Regards
Sumit
sumit
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
|