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 …
Downtime Mode adop R12.2 To run adop in downtime mode, you use the following command line options. In this example, patch 1111111 is applied in downtime mode: $ adop phase=apply patches=1111111 apply_mode=downtime It does not require the prepare phase The important point in downtime mode (1) Release 12.2 patches are not normally tested in downtime …
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 »
We have already installed VirtualBox and downloaded the VM appliance in the last post Now let’s continue with the installation of the 12.2.12 VM template in the Virtual box 1) Check if the Hardware Virtualization is enabled on the Desktop of the Laptop where you have installed the Virtualbox 2) Now Open the Virtual box …
Step by Step R12.2.12 EBS installation on Virtual Box Part -2 Read More »
Oracle recently released a VM template for R12.2.12 on the Software delivery cloud. In this blog post, we will be checking step by step how to build R12.2.12 with a Virtual box on the Desktop or Laptop (1) First install VirtualBox on the Desktop or Laptop. Check the below post on how to do the …
Step by Step R12.2.12 EBS installation on Oracle Virtual Box Read More »
