Here we are presenting ways on how to move lob segment from one tablespace to another (1) First take the initial size of the LOB segment SELECT table_name, column_name, segment_name, a.bytes FROM dba_segments a JOIN dba_lobs b USING (owner, segment_name) WHERE b.table_name = ‘TABLE_NAME’; More queries can be found at How to find space usage …
how to move lob segment from one tablespace to another Read More »
We already know the general practice to apply application patches to R12.2 through online patching Adop(Ad online patching utility) explained R12.2 R12.2 Online patching cycle Summary Let’s explore the steps on how to apply database patches , weblogic patches , 10.1.2 patches , web-tier patches to the R12.2 tech stack. We can apply the same …
How to apply the technology patches to EBS R12.2 Read More »
Sometimes Oracle components may start giving strange issues like coredump or the Operating system is patched, In these cases it is always recommended to try oracle relink to resolve the issues.A Oracle relink is also necessary whenever you install a new release or a patchset or when there is a patch or upgrade to the OS …
Relink Oracle: All, Sqlplus, Oracle ,forms, lsnrctl Read More »
This is part of Oracle SQL tutorial and has good examples, explanation on single row functions in Oracle Sql Functions are programs that take zero or more arguments and return a single value. Functions can be single row ,multiple row functions We will be discussing here Single row functions in SQL What is single row …
FNDCPASS FNDCPASS is an important utility in the Oracle EBS application and it is located in $FND_TOP/bin. It is used to change passwords for apps schema, oracle EBS schema password, and application user password change. $FNDCPASS FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS FNDCPASS apps/apps 0 Y system/manager ORACLE FNDCPASS apps/apps 0 Y system/manager USER …
What is vi editor vi editor is a visual text editor in Unix. It is pronounced as V and I editor. Here we would be learning how to use the vi editor, how to exit vi editors. vi shows you part of your file and allows you to enter commands that change something (add new …
