yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0207241428.67e62ee7_at_posting.google.com>...
> How about this? It's going to be inefficient even though the file is
> sparse:
>
> for i in 10 .. 100000 loop
> execute immediate 'create temporary tablespace aa tempfile
> '/theFS/aa.dbf' size ' || i || 'm;';
> -- drop aa if no exception, otherwise report the free space left as
> the number used
> end loop;
No one ask me to write my opinion on this. However, I tried to find
some place where phrase "bloody stupid idea" fits. In this case this
phrase fits perfectly. :-)
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Fri Jul 26 2002 - 05:22:58 CDT
