Skip to content

Eclipsys Blog: Oracle (3)

-->

Latest Posts

Data Guard: RMAN-06571: Datafile 1430 Does Not Have Recoverable Copy

Introduction In the current data-driven era, businesses leverage data analysis to seize opportunities and gain a competitive edge. This makes it crucial for organizations to have..

Read More

Oracle Database 23ai: SQL Firewall – Part 1: Intergrate SQL-Firewall with Data-Safe

Introduction We live in the data era, where every organization invests significant resources in securing its IT infrastructure. Protecting data is crucial because modern..

Read More

Data Guard (DG): ORA-01111 – Datafile Not Created on StandBy Database

Introduction In today’s data-driven era, protecting data is paramount. Organizations must be prepared to address potential failures by implementing robust disaster recovery..

Read More

Oracle Database 23ai: Fetch Top-N Rows Per Group Queries

Overview: Oracle 23ai introduces partition by clause in fetch first clause to get top-N rows per group. A query’s syntax SELECT …….. FROM …….. ORDER BY , FETCH FIRST , ROWS ONLY..

Read More

Oracle 23ai: JSON Schema Support

Overview: Oracle first introduced the ability to display a JSON schema when they introduced the JSON Data in Oracle 12.2 but without the option to validate the structure of JSON..

Read More

ODA Bare Metal Patching From 19.16 to 19.20

ODA Upgrade from 19.16 to 19.20 Patching Oracle Database Appliance (ODA) Bare Metal Systems involves applying updates to both the operating system and Oracle Software Components...

Read More

Oracle 23ai: Enumeration Domains – List of Values in the Database

Overview: Oracle Database 23ai introduces a new way to create lists of values: enumeration (enum) domains Benefits: Create lists of name-value pairs in the database Query the enum..

Read More

Oracle 23ai: Quick Overview

Oracle Database 23ai Oracle Database 23ai is the next long-term support release of Oracle Database It brings AI to your data with the addition of AI Vector search to Oracle’s..

Read More

Oracle 23ai: Bigfile Tablespace Shrink

Overview: If you try to resize/shrink a datafile before Oracle Database 23ai, you’ll get “ORA-03297: file contains used data beyond requested RESIZE value” because there are..

Read More

License Complexity – Compliance with Eclipsys

Oracle has some of the best technology out there, but with that comes license complexities which can be challenging to track and manage due to the wide variety of products,..

Read More