How to extract DDL for all tablespaces on Oracle Database

oracle-11g-logo

I was needing to extract  DDL for all tablespaces  on Oracle Database . Then, I took  the information about it using a DBMS_METADATA. Thus, follow  how to take this information:

SQL> set heading off;
SQL> set echo off;
SQL> set pages 2000
SQL> set lines 2000
SQL> set long 99999
SQL> spool ddl_tablespaces.sql
SQL> select dbms_metadata.get_ddl(‘TABLESPACE’, tablespace_name) from dba_tablespaces  ;
##HERE WILL BE SHOWN ALL  TABLESPACES DLL ABOUT YOUR DATABASE##
SQL> spool off

I hope this post can help you!

Related posts

Leave a Comment