thank you so much july 24, 2003
reviewer: saminathan seerangan from nj,usa
small typo in the above procedure
line # 46 'select ts.segment_space_management appears 2 times.
| followup: |
thanks -- i fixed that up |
access to dba_* views needed september 17, 2003
reviewer: dusan from czech republic well, this is a bit frustrating! i used to use this excellent utility
(show_space) at many client sites (8i), to investigate space issues. basically,
every schema might use it! now, on 9i, i have to ask access for those views.
isn't it possible to work around this?
| followup: |
instead of me querying the dba_views, you can pass in that information (what
type of tablespace is it in)
use the "8i" like version, just parameterize it to call the proper api |
