Skip to content

Instantly share code, notes, and snippets.

@uilian

uilian/tbsp-ddl-extract.sql

Created April 8, 2014 12:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save uilian/10116157 to your computer and use it in GitHub Desktop.
Save uilian/10116157 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle - extract DDL for all tablespaces
Raw
tbsp-ddl-extract.sql
select dbms_metadata.get_ddl('TABLESPACE','TD_DBCLARIDATA_AUTO') from dual;
set head off echo off
select 'select dbms_metadata.get_ddl(''TABLESPACE'','''
|| tablespace_name || ''') from dual;' from dba_tablespaces;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment