Oracle Database Discussions

hello
dbms_metadata.get_ddl use to generate script of table index schema etc. i want to generate script of my user tablespaces. normally i perform this task from toad now i want to do itself. for this i use following statement but i did not return plz help me to correct it


select dbms_metadata.get_ddl ('TABLESPACE', tablespace_name)
from
(select distinct a.tablespace_name
from dba_tablespaces a, dba_segments b
where a.tablespace_name = b.tablespace_name
and b.owner = 'A23R2');

Also try this
select dbms_metadata.get_ddl ('TABLESPACE', tablespace_name)
from
(select distinct b.tablespace_name
from dba_tablespaces a, dba_segments b
where a.tablespace_name = b.tablespace_name
and b.owner = 'A23R2');