Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tablespaces ddl extract script

Re: tablespaces ddl extract script

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 12 Oct 2005 11:29:43 +0100
Message-ID: <be592d550510120329q63cfe3co25dedb5fbfcdc877@mail.gmail.com>


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_at_gmail.com> wrote:
>
> Friends,
>
> Can any has scripts to extract the ddl of all tablespace with datafile
> defination in a database?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 12 2005 - 05:31:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US