Hello Friends, In this article we are going to show you how to get ddl of all tablespaces in oracle.
Get DDL of All Tablespaces Oracle
Use below query to get ddl of all tablespaces in oracle.
SQL>set heading off;
SQL>set echo off;
SQL>Set pages 999;
SQL>set long 90000;
SQL>spool ddl_of_tablesspace.sql
SQL>select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces tb;
SQL>spool offIf you really like this article, please subscribe my YouTube channel.
Read - How to Recover Controlfile without Backup?
3 thoughts on “How To Get Ddl Of All Tablespaces In Oracle”