SQL> select dbms_metadata.get_ddl('TABLESPACE','TS_NAME') from dual;
google and metalink are your friends
On 10/12/05, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote:
>
> Friends,
>
> Can any has scripts to extract the ddl of all tablespace with datafile
> defination in a database?
>
