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
Month: April 2015
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…
Get the body of the procedures in Oracle
Follow below get the body of the procedures in Oracle Database: SQL> SELECT text FROM all_source WHERE name='&name' ORDER BY line; brunors
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…