Blogs

Database 20c docs

articles: 

Now available!
https://docs.oracle.com/en/database/oracle/oracle-database/20/books.html

Going through the New Features guide, there is a shed load of wonderful enhancements. Then you look at the Licensing guide, and most of them require Exadata or Oracle Cloud or both.

Recover a database using RMAN but failing to open redo

articles: 

When using RMAN to restore and recover the database, it seems to work OK - no obvious errors during the restore / recovery, as far as I can see. The issue seems to be when I try to 'alter database open resetlogs'... after this the database shuts down. At this point, I don't really care about losing some of our data, this is just a test system, my main concern is how to get the database working again.

Oracle version 12.1.0.

1. I startup with nomount.

RMAN> startup nomount;

DISKSPACE MONITORING

articles: 

DISKSPACE MONITORING
Written JP Vijaykumar
Date Jan 4th 2020
Modified Jan 5th 2020
**************************************************************
This article/script is provided for educational purpose ONLY.
The readers are advised to make necessary changes to the script as may be required for their use in their respective environments.
Pls test these scripts thoroughly in a lower environment, ONLY if you are satisfied with the tests' results, then ONLY use in any

How to move a table from one schema to another

articles: 

Many times I've seen the question on forums "How can I move a table from one schema to another?" and the answer is always that you can't. You have to copy it. Or export/import it. Well, here's a way. It assumes that you are on release 12.x and have the partitioning option.

Audit table field value change

articles: 

From the below table example, I'm trying to identify only the records where VAL_IN changed. So I need to see only 4 records in the below example.
I've been reading about LEAD / LAG and think this is probably the function I need to use, but have not had luck with returning results. Can someone please help push me in the right direction.

Where to download Oracle Developer 10g

articles: 

Where to download Oracle Developer 10g

Oracle now supported on VMware

Oracle corporation will (as of 24 September 2019) support customers running on VMware.

Return TYpe (tablet) as output parameters.

articles: 

Good afternoon people!

I have a procedure in Oracle with various functions of calculations, type simulator. So, I want to assemble a type with output parameters reading this data and bring the results of these functions in real time, because I want to display them as output lines on a front (web screen). I already created the types objects and table. However, I am having difficulty assembling, because I do not know well Type. Can someone help me? Thanks

19c Standard Edition permits 3 PDBs per CDB

articles: 

A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database.

Decision Tree Algorithm in pl/sql

articles: 

Decision Tree Algorithm in pl/sql
Author JP Vijaykumar
Date Sept 14th 2019

Pages

Subscribe to RSS - blogs