How To Get Ddl Of All Tablespaces In Oracle

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 off

If you really like this article, please subscribe my YouTube channel.

Read – How to Recover Controlfile without Backup?

subscribe on youtube

1 thought on “How To Get Ddl Of All Tablespaces In Oracle”

Leave a Comment

%d bloggers like this: