Was wondering if one of you great DBA's out there can help one of us
Intermediates.
Here's the issue. I need to write a script that will return the count of
records in all my objects then do size estimation on that table for a
recreate. What the Initial and the next should be. I was thinking of
creating a temp table and storing the record count then storing the
bytes/1024 "KB" from the v$segment view then a select on the temp table
for (record_count/KB)/4 for initial and next. I am trying to get them
into 4 extents. Does anybody have a better idea or way of doing this.
Tony
Received on Thu Nov 09 2000 - 20:28:22 CET