Database encryption is a important concept these days because of security breaches . It is common practice to have database encryption enabled in Oracle database. Encryption can be present at two Level TDE ( Transparent Data encryption) : This is setup for Table levelTSE (Tablespace encryption): This is setup for Tablespace level Here is how […]
How to make index invisible in oracle
What are Invisible Indexes? Beginning with Oracle Database 11g Release 1, you can create invisible indexes or make an existing index invisible. An invisible index is ignored by the optimizer unless you explicitly set the OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter to TRUE at the session or system level. Unlike unusable indexes, an invisible index is maintained during […]
How to Drop the index in Oracle
You can drop an index in oracle using DROP INDEX command. It removes the named index. The general Syntax is drop index <schema name>.<index name> ; Here schema name is the owner of the index and index name is the index name. If you dont provide the schema name, then it is assumed the index […]
How to use Analytic functions in oracle (Over Partition by Keyword)
This post is part of Oracle SQL tutorial and we would be discussing Analytic functions in oracle(Over by partition) with examples, detailed explanation . We have already studied about Oracle Aggregate function like avg ,sum ,count. Lets take an example First lets create the sample data CREATE TABLE “DEPT” ( “DEPTNO” NUMBER(2,0), “DNAME” VARCHAR2(14), “LOC” […]
How to delete the manage server in R12.2
I was working on R12.2 Test env and I was suppose to decrease the JVM for the oacore(delete the manage server) The procedure to increase or decrease JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms and forms-c4ws services were deployed as applications on OC4J instances and were […]
How to add the manage server in R12.2
I was working on R12.2 Test env and I was suppose to increase the JVM(add the manage server in R12.2) for the oacore to sustain the load The procedure to increase JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms and forms-c4ws services were deployed as applications on […]