📋Steps in this guide1/1

Get DDL of all tablespaces

set heading off; set echo off; Set pages 999; set long 90000; spool ddl_tablespace.sql select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces tb; spool off

oracle configurationintermediate

by OracleDba

12 views

Get DDL of all tablespaces

Code/Command (click line numbers to comment):

set heading off;
set echo off;
Set pages 999;
set long 90000;
spool ddl_tablespace.sql
select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces tb;
spool off

Comments (0)

Please to add comments

No comments yet. Be the first to comment!