Patch Wizard is a tool provided by Oracle for finding the impact of application patches on the Environment. It is a handy tool and shows all the impacted files and appropriate action can be taken based on that information. It is an extremely important tool and here I will explain how to use Patch Wizard, […]
How to use Patch wizard in Oracle EBS environment Read More »
APPLSYSPUB is the database schema. it is the first schema that is used in any connection in Oracle apps. APPLSYSPUB default password is PUB. It is not an application user and thus you cannot find that in the FND_USER table in the Oracle database of Oracle applications Oracle forms, and OACORE all connect to it
Introduction We often want to run pre-defined jobs at different schedules. Oracle database provides dba_jobs/dbms_scheduler (Oracle Database job scheduler) for scheduling pre-defined jobs. Information about DBA_JOBS ( Till 9i) Query to see the jobs running through dba_jobs select /*+ rule */ * from dba_jobs_running; or select /*+ ordered */ * from dba_jobs_running; Common Reason why jobs
How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER Read More »
External table is one of the important feature in oracle , we will exploring external table in oracle with example in this post What are EXTERNAL TABLES in Oracle? 1)External tables are read-only tables where the data is stored in flat files outside the database 2) You can use the external table feature to access external
Oracle External tables Read More »
Oracle provides the EBS data model comparison report to view the static database object definition changes between two EBS releases Applicable Releases Benefits of EBS Data Model Comparison Report We can view the Per product database object comparison between two releases for thefollowing object types -Regular tables, Partitioned tables, Index organized tables, Global temporary tables, Queued
EBS Data Model Comparison Report Read More »
The Oracle Database Interactive Quick Reference is a multimedia tool for various terms and concepts used in the Oracle Database. Built as a multimedia web page, this diagram provides descriptions of database architectural components and references to relevant documentation. This is a beneficial reference and cheat sheet for writing custom data dictionary scripts, locating Oracle
Oracle Database Interactive Quick Reference Guide | 11g ,12c, 19c & 23c Read More »
