We recently helped a client migrate from Oracle Database XE to SE2. There was no choice – they had reached the XE 12GB data limit. Going to SE2 is effectively a downgrade because XE has all the EE features, so …
We just hit a silly problem with ORDS 22.x. When deploying ORDS to Tomcat, you have to create a version of the ords.war file that has the location of the ORDS configuration directory embedded within it. You do this by …
I first configured a WAF a couple of years ago, and I thought it was a splendid product offering all the features and counter measures you might want to help protect and enhance your web site against Layer 7 threats. …
ORDS version 21 was released in May, we tested and rolled it out in June. But once live, a problem popped up: numerous executions of this statement, SELECT COUNT(1) FROM SYS.ALL_SYNONYMS WHERE OWNER = ‘PUBLIC’ AND SYNONYM_NAME = ‘APEX_RELEASE’ AND …
Sometimes one gets the feeling that something is needlessly difficult. This is one of these things, and the difficulty has some history. Apache FOP is probably as close as one can get to an industry standard facility for creasting PDFs. …
What block size should you use? For what purpose? How about tablespaces in different block sizes? Any opinions? When support for multiple block sizes was introduced, I was working for Oracle Uni and did have some (very restricted) access to …
Database release 19.7 (ie, 19c with the April 2020 RU) is at last certified for OL8, but there may be some hacking needed to get it installed. This certification is long overdue: our security admin has been pushing for the …
Recently I’ve been working on tuning some distributed queries. This is not always straightforward. This is not a comprehensive discussion of the topic, rather a description of how one might approach the problem. The query I’m using for this demonstration …
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.
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 …
A very nice licensing change in 19c: you can now have up to three PDBs in a Standard Edition Multitenant database. Apart from the obvious advantage of being able to do some database consolidation, it gives SE2 users the ability …
What is Privilege Analysis (included in Oracle Database 19c Enterprise Edition) Database 19c is nothing more than the re-badging of release 12.2.0.3: the terminal 12c release that will have extended support until March That having been said, there are a …
Do you know about multiple domain certificates? If not you may have to learn quickly, because Oracle has changed the way they are handled in release 12.2. This is going to break a lot of applications. A multiple domain certificate …
Will upgrade from 12.1 to 12.2 break your applications? It may if your developers are using JSON. In both release 12.1 and 12.2, there are these keywords: orclx> select * from v$reserved_words where keyword like ‘JSON%’ order by 1; KEYWORD …
SkillBuilders Oracle Database Manager (SB-ODM) is a FREE lightweight Oracle database administration tool. SB-ODM is EASY To USE! It’s chock-full of features for everyday administration tasks including rman backup, datapump database export, datapump database import, apex exports, storage management, Oracle …