Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: tablespaces ddl extract script
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-lReceived on Wed Oct 12 2005 - 05:31:48 CDT