Hot backup database cloning is more suitable for databases that are running 24/7 types of databases and is done using the hot backup. For hot database cloning, the database has to be in archivelog mode and there is no need to shut down the database. The high-level steps for How to clone the database using […]
How to clone the database using Manual Hot backup Read More »
Cold backup Database Cloning is the simplest method to clone the database. The disadvantage of this approach is that database will be down during cold backup. The high-level steps for How to clone the database using Cold backup Database Cloning1) Take the cold backup of the database to be cloned2) Copy all the backup files to
How to clone the database using manual cold backup Read More »
R12.2 is the latest release of the E-Business Suite from Oracle. It contains the latest technology stack and it contains many new features. Most important is the online patching feature. Oracle R12.2 Architecture Difference between R12.1 and R12.2 technology stack Important things about Oracle R12.2 Architecture FS-1 (Production file system) Used by the current users of
Oracle E-Business Suite Architecture in 12.2 Read More »
Pagination is common in Web-based applications. The user inputs a set of criteria, which runs a query and then lets the user click the Previous and Next buttons to page through the result set. To achieve this paging functionality, the application needs to be able to get a certain set of rows from the Database
Pagination in Oracle Read More »
Top-N Queries are common in Oracle database. People will often look for the below queries oracle top 100oracle select top 10oracle top 1000 rowsselecting top 10 rows in oraclehow to select top 10 rows These are essentianlly the same queries . They are called Top-N queries Let’s take a look at the different methods in
Top-N Queries in Oracle Read More »
We can have different languages installed in Oracle apps. Here is the Query to check languages installed in oracle apps select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in (‘B’, ‘I’); The Installed_Flag has 3 values I- InstalledB- BaseD- Disabled Example sqlplus apps/<apps pass>select LANGUAGE_CODE from fnd_languages where INSTALLED_FLAG in (‘B’, ‘I’);LANG_____USDFR Important Points The above query
Query to check languages installed in oracle apps Read More »
