HOW TO EXTRACT DLL FOR TEMPORARY TABLESPACE ON ORACLE DATABASE

April 26, 2015 brunors

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

brunors

Related posts

• August 16, 2023 brunors 0

  Oracle Database Growth Monitoring Script

  The Oracle Database Growth Monitoring Script is a tool designed to track and analyze the growth...
• May 29, 2023 brunors 0

  PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not currentPL/SQL package SYS.DBMS_RCVMAN version 19.10.00.00 is too old

  Recently, I undertook the task of upgrading an Oracle database from version 19.10 to 19.18. As...
• May 29, 2023 brunors 0

  Enable online status for all Oracle database datafiles

  I have executed a database migration by transitioning from a physical active data guard to a...