Monday, June 4, 2012

Extract Tablespaces with dbms_metadata.get_ddl



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

No comments:

Post a Comment