How to get the DDL of a Tablespace in Oracle :
To find the DDL (Data Definition Language) of a tablespace in Oracle Database, we can work the DBMS_METADATA package.A tablespace consists of one or more physical data files. DDL of…
To find the DDL (Data Definition Language) of a tablespace in Oracle Database, we can work the DBMS_METADATA package.A tablespace consists of one or more physical data files. DDL of…
Tables are an essential component that store data in a structured manner. At times, you may need to find the DDL of a table in Oracle database, which is a…
Here we will learn how to enable-disable archivelog mode in Oracle database. But why do we enable-disable archivelog mode in oracle database and why it is important? First of all,…
1.SELECT_ANY_DICTIONARY: SELECT GRANTEE, PRIVILEGEFROM DBA_SYS_PRIVSWHERE PRIVILEGE='SELECT ANY DICTIONARY'AND GRANTEE NOT IN ('DBA','DBSNMP','OEM_MONITOR','OLAPSYS','ORACLE_OCM','SYSMAN','WMSYS'); 2.SELECT ANY TABLE: SELECT GRANTEE, PRIVILEGEFROM DBA_SYS_PRIVSWHERE PRIVILEGE='SELECT ANY TABLE'AND GRANTEE NOT IN ('DBA', 'MDSYS', 'SYS', 'IMP_FULL_DATABASE', 'EXP_FULL_DATABASE','DATAPUMP_IMP_FULL_DATABASE',…
If you want to know how to query the alert log file then you are in the right place. Today we will learn how to check the alert log using…
Step-by-Step Applying PSU Patch : 1.Download the latest Opatch Tool and latest patch from My Oracle Support.p28163133_122010_Linux-x86-64.zip --->PSU patchp6880880_122010_Linux-x86-64.zip --->Opatch Review readme file on Patch 28163133. 2.Copy the patch and…