HOW TO EXTRACT DLL FOR TEMPORARY TABLESPACE ON ORACLE DATABASE

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

CONNECT USER USING GRANT CONNECT THROUGH

Oracle Database has a grant that you can use to connect through another user. For example, I have the use ”A” and I want to connect with this user through the user ''brunors''. It possible to do it, but you need to give the grant connect through to user ''brunors''. I am going to show how it works now.. Let’s go… SQL> create user brunors identified by <brunors’s password here>; User created. SQL> grant connect , resource , create session to brunors; Grant succeeded. SQL> ALTER USER A  GRANT CONNECT…

TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation IBM/AIX RISC System/6000 Error: 1: Not owner

I was trying to start the Listener when … Welcome to LSNRCTL, type “help” for information. LSNRCTL> set curr LISTENER_DB Current Listener is LISTENER_DB LSNRCTL> start Starting /oracle/PIQ/112_64/bin/tnslsnr: please wait… TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production System parameter file is /oracle/DB/112_64/network/admin/listener.ora Log messages written to /oracle/diag/tnslsnr/host/listener_db/alert/log.xml Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=DB.WORLD)) TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation IBM/AIX RISC System/6000 Error: 1: Not owner Then, I check whether the directory /var/tmp/.oracle or /tmp/.oracle there are in the server. After that, I renamed…