Follow below get the body of the procedures in Oracle Database: SQL> SELECT text FROM all_source WHERE name='&name' ORDER BY line; brunors
Category: Oracle Database General
How to extract DDL for all users on Oracle Database
I was needing to extract DDL for all users 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> set lines 2000 SQL> spool ddl_users.sql SQL> select dbms_metadata.get_ddl(‘USER’,username) FROM dba_users; ##HERE WILL BE SHOWN ALL DLL USERS OF YOUR DATABASE## SQL> spool off I hope this post can help you! brunors
How to extract DDL for all roles on Oracle Database
I was needing to extract DDL for all roles 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 ddl_roles.sql SQL> select dbms_metadata.get_ddl('ROLE', ROLE) from dba_roles; ##HERE WILL BE SHOW ALL ROLES DLL ABOUT YOUR DATABASE## SQL> spool off I hope this post can help you! See ya, Bruno Reis. brunors
Installing Oracle Linux 5.4 – 32 bits on Oracle VM VirtualBox – Part 1
In this section I will explain the first part about the simple installation of Oracle Linux 5.4- 32 bits on Oracle VM VirtualBox. The media can be found on Oracle Software Delivery Cloud – Oracle Linux and Oracle VM (https://edelivery.oracle.com/linux), when was downloaded on 01 January 2015. After login using your Oracle account (If you don’t have one, you must do), read the text and mark the options ” I have reviewed the terms of the License Agreement or the Oracle License Agreement above and accept its terms ” …
How to extract DDL for all tablespaces on Oracle Database
I was needing to extract DDL for all 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 lines 2000 SQL> set long 99999 SQL> spool ddl_tablespaces.sql SQL> select dbms_metadata.get_ddl(‘TABLESPACE’, tablespace_name) from dba_tablespaces ; ##HERE WILL BE SHOWN ALL TABLESPACES DLL ABOUT YOUR DATABASE## SQL> spool off I hope this post can help you! brunors