miércoles, 30 de julio de 2025
Oracle Database 19c, con R.U. 19.28 suma características de 23ai al release.
miércoles, 23 de julio de 2025
Generative AI for Beginners-Videos
🚨 BREAKING: Microsoft just dropped an 18-episode series called "Generative AI for Beginners".
— Mr Nikola (@nikola_mr64990) July 23, 2025
Ideal for beginners, developers, and AI enthusiasts looking to build a solid foundation.
Here’s a breakdown (Save this👇):🧵 pic.twitter.com/wQChdqKaB0
Oracle Hot Topics, Jul 23, 2025
Knowledge Articles
Knowledge Article Product Area Last Updated
Autonomous Health Framework (AHF) - Including Trace File Analyzer and Orachk/Exachk
Oracle Database Exadata Express Cloud Service Generation 1 - Exadata Cloud at Customer (First Generation Cloud Machine) Oracle Database Cloud Exadata Service Oracle Database Cloud Service Oracle Cloud Infrastructure - Database Service Oracle Exadata Storage Server Software Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Database Backup Service Gen 2 Exadata Cloud at Customer Oracle Cloud Infrastructure - Exadata Cloud Service Mon, 21 Jul 2025 18:19 GMT-06:00
SRDC – How to Collect Data for creating MOS SR - Oracle Banking Payments
Oracle Banking Payments Wed, 23 Jul 2025 03:26 GMT-06:00
miércoles, 9 de julio de 2025
Escalación no deseada de privilegios a nivel de base de datos Oracle 19c/23ai
“The Protection of Information in Computer Systems”,Proceedings of the IEEE, Vol. 63, No. 9, pp. 1278–1308 (septiembre 1975)
Oracle Hot Topics Jul 07 2025
Bugs
Bug Product Area Bug ID Last Updated
INCORRECT RESULT FROM UNIFIED_AUDIT_TRAIL WHEN COALESCE FUNCTION IS USED
Oracle Database - Enterprise Edition 38052584 Wed, 9 Jul 2025 04:12 GMT-06:00
Knowledge Articles
Knowledge Article Product Area Last Updated
Oracle Database - Enterprise Edition Tue, 8 Jul 2025 06:02 GMT-06:00
"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support
domingo, 15 de junio de 2025
¿Puede una máquina tener un motivo de vida?
viernes, 6 de junio de 2025
Oracle Hot Topics, 06 Jun, 2025
Bugs
Bug Product Area Bug ID Last Updated
ORA-600 [KTATMKREF-RS] ERRORS IN THE ALERT LOG POST-PATCH 37260974
Oracle Database - Enterprise Edition 37690446 Fri, 6 Jun 2025 08:22 GMT-06:00
Knowledge Articles
Knowledge Article Product Area Last Updated
MDBUtil: GI Management Repository configuration tool
Oracle Database Cloud Service Generation 1 - Exadata Cloud at Customer (First Generation Cloud Machine) Oracle Database Cloud Exadata Service Oracle Database Exadata Express Cloud Service Oracle Cloud Infrastructure - Database Service Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Database Backup Service Fri, 6 Jun 2025 08:05 GMT-06:00
"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support
miércoles, 4 de junio de 2025
Valor númerico en la columna SNAPSHOT_TIME de la vista cdb_pdb_snapshots
SELECT con_name, snapshot_name, snapshot_scn,
TO_CHAR(TO_DATE('1970-01-01','YYYY-MM-DD') + NUMTODSINTERVAL(SNAPSHOT_TIME, 'SECOND'),'DD/MM/YYYY HH24:MI') as TIME_SNAP,
full_snapshot_path
FROM cdb_pdb_snapshots
ORDER BY con_id, snapshot_scn;
-SNAPSHOT_TIME es el número de segundos desde el Unix epoch (01/01/1970 00:00:00 UTC).
-NUMTODSINTERVAL(SNAPSHOT_TIME, 'SECOND') convierte ese número a un intervalo de tipo INTERVAL DAY TO SECOND.
-Se lo sumás a TO_DATE('1970-01-01','YYYY-MM-DD') para obtener un valor DATE.
-TO_CHAR(..., 'DD/MM/YYYY HH24:MI') convierte la fecha a texto con el formato deseado.
SELECT con_name, snapshot_name, snapshot_scn,
TO_CHAR( FROM_TZ( CAST(TO_DATE('1970-01-01','YYYY-MM-DD') + NUMTODSINTERVAL(SNAPSHOT_TIME, 'SECOND') AS TIMESTAMP),
'UTC' ) AT TIME ZONE 'America/Costa_Rica', 'DD/MM/YYYY HH24:MI' )
AS SNAPSHOT_DATE_LOCAL,
full_snapshot_path
FROM cdb_pdb_snapshots
ORDER BY con_id, snapshot_scn;
jueves, 29 de mayo de 2025
OracleForms14c : Más fuerte que el tiempo por: Richard Novillo
Ordenar resultados en distintos idiomas, por Javier Morales
En el OCI existen varios tipos de almacenamiento que podemos utilizar.
La sexualidad y los entornos de IA.
Oracle Hot Topics: May 29, 2025
Alerts
Alert Product Area Last Updated
ALERT: Disable Transparent HugePages on SLES11, RHEL6, RHEL7, RHEL8, OL6, OL7, OL8 and UEK2 and above
Generation 1 - Exadata Cloud at Customer (First Generation Cloud Machine) Oracle Database Exadata Express Cloud Service Oracle Database Cloud Exadata Service Oracle Database Cloud Service Oracle Cloud Infrastructure - Database Service Oracle Database - Standard Edition Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Database Backup Service Wed, 28 May 2025 09:20 GMT-06:00
Bugs
Bug Product Area Bug ID Last Updated
DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER$ TABLE
Oracle Database - Enterprise Edition 29213893 Thu, 29 May 2025 08:33 GMT-06:00
Knowledge Articles
Knowledge Article Product Area Last Updated
ASMLib Devices Not Discovered with Diskstring as 'ORCL:*'
Generation 1 - Exadata Cloud at Customer (First Generation Cloud Machine) Oracle Database Exadata Express Cloud Service Oracle Database Cloud Exadata Service Oracle Database Cloud Service Oracle Cloud Infrastructure - Database Service Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Database Backup Service Wed, 28 May 2025 21:01 GMT-06:00
lunes, 26 de mayo de 2025
Oracle Hot Topics: May 26, 2025
Bugs
Bug Product Area Bug ID Last Updated
DBA_SEGMENTS VIEW REPORTS TABLE NEGATIVE SEGMENT SIZE
Oracle Database - Enterprise Edition 28620376 Mon, 26 May 2025 11:23 GMT-06:00
Knowledge Articles
Knowledge Article Product Area Last Updated
Troubleshooting Guide: ORA-00800 - [Set Priority Failed], [VKTM]
Oracle Database Cloud Exadata Service Generation 1 - Exadata Cloud at Customer (First Generation Cloud Machine) Oracle Database - Enterprise Edition Oracle Cloud Infrastructure - Exadata Cloud Service Gen 2 Exadata Cloud at Customer Mon, 26 May 2025 00:44 GMT-06:00
"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support
miércoles, 21 de mayo de 2025
Oracle Hot Topics: May 21, 2025
Bugs
Bug Product Area Bug ID Last Updated
RAT: REPLAY FILTER DOESN'T WORK ON PLUGGABLE DATABASE
Oracle Database - Enterprise Edition 29326016 Wed, 21 May 2025 08:29 GMT-06:00
Knowledge Articles
Knowledge Article Product Area Last Updated
Exadata Database Machine and Exadata Storage Server Supported Versions
Oracle Exadata Hardware Oracle Database Cloud Exadata Service Oracle Database Cloud Service Exadata Database Machine X2-2 Hardware Oracle Database Exadata Express Cloud Service Generation 1 - Exadata Cloud at Customer (First Generation Cloud Machine) Oracle Platinum Services Oracle Cloud Infrastructure - Database Service Oracle Exadata Storage Server Software Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Cloud Infrastructure - Exadata Cloud Service Gen 2 Exadata Cloud at Customer Oracle Database Backup Service Wed, 21 May 2025 11:05 GMT-06:00
Release Schedule of Current Database Releases
miércoles, 14 de mayo de 2025
Oracle Hot Topics: May, 14 2025
Bug Product Area Bug ID Last Updated
ORA-600 [KDIFIND:KCBGET_24]
Oracle Database - Enterprise Edition 12410357 Wed, 14 May 2025 04:19 GMT-06:00
Knowledge Articles
Knowledge Article Product Area Last Updated
RAC and Oracle Clusterware Best Practices and Starter Kit (Linux)
Oracle Database Cloud Exadata Service Oracle Database Cloud Service Oracle Database Exadata Express Cloud Service Oracle Cloud Infrastructure - Database Service Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Database Backup Service Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) Wed, 14 May 2025 02:22 GMT-06:00
"This message contains information according to the preferences you set in My Oracle Support. To modify your settings or to turn off this automated message, login to My Oracle Support (http://support.oracle.com) and click on 'More' -> 'Settings' -> 'Hot Topics E-mail'" My Oracle Support
sábado, 10 de mayo de 2025
Clonando un PDB dentro de un contenedor de base de datos, sólo con METADATA
Es posible clonar un base de datos acoplada dentro de un contenedor que sólo lleve la METADATA de los objetos y no los datos?
Si es posible. Veamos un ejemplo.
Tenemos un contenedor de base de datos con los siguientes PDBs.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
4 PROD_DR MOUNTED
5 PDB2 READ WRITE NO
6 PDB1 READ WRITE NO
SQL>
Vamos a conectarnos al PDB1 y vamos a validar la cantidad de registros
que tiene la tabla t2 del esquema TEST.
SQL> alter session set container=PDB1;
Session altered.
SQL> select count(*) from test.t2;
COUNT(*)
----------
1000
La tabla como vemos, tiene 1000 registros. Ahora vamos nuevamente para el CDB#ROOT.SQL> connect / as sysdba
Connected.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
4 PROD_DR MOUNTED
5 PDB2 READ WRITE NO
6 PDB1 READ WRITE NO
Vamos a crear un nuevo PDB con el nombre de "PDB1_NODATA" y lo que vamos a hacer distinto
es que vamos a colocar las palabras "no data" al final del comando.
SQL> create pluggable database pdb1_nodata from PDB1 no data;
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
4 PROD_DR MOUNTED
5 PDB2 READ WRITE NO
6 PDB1 READ WRITE NO
7 PDB1_NODATA MOUNTED
Una vez creada la nueva PDB vamos a abrir la base de datos y nos conectamos a la misma.
SQL> alter pluggable database PDB1_NODATA open; Pluggable database altered. SQL> alter session set container=PDB1_NODATA; Session altered.
Verificamos la existencia y el contenido de la tabla T2 en el esquema TEST.
SQL> select count(*) from test.t2;
COUNT(*)
----------
0
SQL> desc test.t2
Name Null? Type
----------------------- -------- ---------
X NUMBER
Y CHAR(1)
SQL>
Como pueden observar el objeto existe, pero no tiene los registros que tenía en el PDB de origen.
LAOUCTOUR2025: Generación de Datos Sintéticos con IA: Más Allá de los Datos Reales
OUGPY | Grupo de Usuarios Oracle del Paraguay
LAOUCTOUR2025: El Caballo de Troya Digital: ¿Estás Invitando a Hackers a tu Base de Datos?
Cómo desinfectar el ingreso de instrucciones de lenguaje SQL por parte del usuario para ayudar a prevenir la inyección de código SQL en la base de datos Oracle.
Esta es una de charlas que estaré brindando durante el #LAOUCTOUR2025 en el #Paraguay, #Chile y #Argentina.
OUGPY | Grupo de Usuarios Oracle del Paraguay
AROUG - Grupo de Usuarios Oracle de Argentina
ITALIANZA presenta: ¡El futuro de tus aplicaciones empieza ahora!
Súmate a un webinar organizado por IT Alianza, donde exploraremos cómo Oracle Apex y la IA están transformando el desarrollo tecnológico. ¡Inscríbete hoy y reserva tu lugar! https://italianza.com.py/cursos/inscripcion/









.jpg)







