HOW TO EXTRACT DLL FOR TEMPORARY TABLESPACE ON ORACLE DATABASE

brunors

oracle-11g-logo

I  was needing to extract  DDL for temporary 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 long 99999
SQL> spool tablespace_temp.sql
SQL> select dbms_metadata.get_ddl('TABLESPACE', tablespace_name) from dba_temp_files;
##HERE WILL BE SHOW TEMPORARY  TABLESPACES DLL ABOUT YOUR DATABASE##
SQL> spool off

I hope this post can help you!

See ya, Bruno Reis

Related posts

One Thought to “HOW TO EXTRACT DLL FOR TEMPORARY TABLESPACE ON ORACLE DATABASE”

  1. magilvaganan
    June 18, 2019 at 4:59 pm

    hey magivagana thanks for the script

    Reply

Leave a Comment