FIXING APEX ERROR DURING UPGRADATION IN PDB
FIXING APEX ERROR DURING UPGRADATION IN PDB INTRODUCTION :- I got the following APEX error in 19C pluggable database while upgrading the PDB database from lower version (12C) to higher…
Read MoreProgressive Web Application –Next Generation Mobile Application Development with Oracle Apex
Introduction: Progressive Web Applications are web apps that use service workers, manifests, and other web-platform features in combination with progressive enhancements to give users an experience like native apps.…
Read MoreUndo Corruption in Oracle
What is Undo ? Undo records are used to: Oracle Database creates and manages information that is used to roll back, or undo, changes to the database. Such information consists…
Read MoreRedo log corruption
What is a Redo log corruption? In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Each redo log file consists of…
Read MoreWonders in AWS RDS – Good Deployment techniques
Introduction Amazon Web Service offers a diverse range of products and services to clients across the globe and shapes. Amazon RDS is one of the most popular and notable services…
Read MoreOracle Blob and Clob Datatypes
CLOB and BLOB are two types of data types used in databases to store large amounts of data. BLOB: BLOB, or Binary Large Object, is used to store binary data such as images, audio, video, and other multimedia objects. It is an extension of the VARBINARY data type and can store up to 2GB of data.Using CLOB and BLOB data types can be beneficial in many situations. CLOB:CLOB, or Character Large Object, is used to store textual data and is used for large strings of text. It is an extension of the VARCHAR data type and can store up to 4GB of data if you have a large document or image you need to store, you can use a CLOB or BLOB data type to store it.storage space is occupied more in the database, so you should be careful about when and how you use them. To query for CLOB or BLOB datatypes,…
Read Morewhat are the oracle index status
Oracle index is a database object that is used to improve the performance of certain queries by providing direct access to the data in a table. Indexes are created on columns and contain entries that point to the data in the table. An index can be unique or non–unique and can be created on one or more columns. some of status are below. 1.Unusable 2.N/A 3.Valid 4.Invalid 1.UNUSABLEAn Oracle index can become unusable if the underlying table has been modified or dropped, or if the index has been corrupted. To fix this, you need to re–create the index.The data is not in the order specified by the SORTED INDEXES clause ALTER INDEX [schema.]indexname REBUILD ONLINE;…
Read MoreOracle Cloud – GL Journal Import by using FBDI process
Oracle Cloud – GL Journal Import by using FBDI Process Overview FBDI Journal Import Oracle Cloud made life easy for the data entry in creating/preparing journal entries in general…
Read MoreOracle Cloud – How to Install ADFDI Plug In
Oracle Cloud – How to Install ADFDI Plug In Introduction: ADFDI is an excel plug-in needed to use any spreadsheet functionality within Oracle Cloud (i.e. upload journal via spreadsheet,…
Read MoreOracle Cloud – How to do Form Personalize to stop showing ICONS on spring board
Oracle Cloud – How to do Form Personalize to stop showing ICONS on spring board Introduction: If we need to hide/display spring board icons or extend the application in…
Read More