Re: tablespaces ddl extract script

You may use following script to extract ddl for tablespaces:

set pagesize 0
set long 100000
set heading off
set linesize 132
set feedback off

select dbms_metadata.get_ddl('TABLESPACE',dba_tablespaces.tablespace_name) from dba_tablespaces;

Regards
Rafiq

From: David Sharples <davidsharples_at_gmail.com> Reply-To: davidsharples_at_gmail.com
To: The Human Fly <sjaffarhussain_at_gmail.com> CC: Norman Dunbar
<norman.dunbar_at_environment-agency.gov.uk>,oracle-l_at_freelists.org Subject: Re: tablespaces ddl extract script Date: Wed, 12 Oct 2005 11:58:33 +0100

you can write a simple query to get all the tablespaces very easily

On 10/12/05, The Human Fly <sjaffarhussain_at_gmail.com> 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. '
>

--
http://www.freelists.org/webpage/oracle-l