you can write a simple query to get all the tablespaces very easily On 10/12/05, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote: > > When we use dbms_metadata.get_ddl, only one tablespace we can get at > a given time. I have 100 tbs and difficult to use this. > I have found a good script at metalink. ' >