Businesses are finding innovative ways to use Oracle Cloud Infrastructure (OCI) every year to foster innovation and development. This year is no exception, with Oracle releasing a plethora of new…
Read MoreTXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…
Read MoreAutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…
Read MoreFIXING 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 MoreIntroduction: 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 MoreWhat 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 MoreWhat 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 MoreIntroduction 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 MoreCLOB 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 MoreOracle 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 More