Arvind Toorpu

Nice and easiest way to to extract the DDL for all tablepaces..  Generate the DDL using the below query and you can re create the table spaces in any environment with any changes you want to make. set heading off;set echo off;Set pages 999;set long 90000; spool ddl_list.sql select dbms_metadata.get_ddl(‘TABLESPACE’,tb.tablespace_name) from dba_tablespaces tb; spool off…

Upgrading Opatch to Latest Version : It is so simple to upgrade th Opatch version for your database. I will check my current version of Opatch [oracle@linux5 OPatch]$ opatch version Invoking OPatch 10.2.0.4.2 OPatch Version: 10.2.0.4.2 OPatch succeeded. Now download the latest Opatch version from oracle support site.in this case I have downloaded p6880880_101000 &…

Linux OS is a virtual memory system like any other modern operating system. The Virtual Memory Management system of Linux includes: Paging Swapping HugePages Slab allocator Shared memory When almost all of the available physical memory (RAM) is started to be used in Linux, the kernel will start to swap out pages to the swap…

will start the post soon with all installation steps & snapshots ………

Description This script all table and system privileges granted to a user.  The scripts also takes into acount those privileges assigned via  roles granted via roles Parameters username – The username to display privileges for SQL Source REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. set echo offset verify offset pages 200col granted_role…