I'm trying to generate a script to capture all ddl for tablespaces. I can't use full export due to some storage sizing differences, my development database will be much smaller than production. So, I started looking into using dbms_metadata.get_ddl, but I have not found a way to generate the sql for all tablespaces at once, it works if you want to create one at a time.
I tried creating my own sql script, but can't find where the uniform extent size is stored in the dba_tablespaces. Any guidance as to how to get this accomplished is very well appreciated. I have about 200 tablespaces running 9.2.0.3.

Thanks
Patricia
Oracle LazyDBA home page