Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: 12c
Transportable Tablespace–part 2
I did a little demo of sharing a tablespace between two databases a few days back – you can see the details here or by just scrolling down if you’re on the home page. To avoid clouding the demonstration I omitted something in the…
Sharing a tablespace between 2 databases
I was reading an interesting discussion today about multiple databases each containing large amounts of read-only data. If that read-only data is common, then it would make sense to have a single copy of that data and have both databases share it. Well, as…
12c Release 2, set feedback enhancement in SQL PLus
There’s a nice little touch to the “set feedback” command in SQL PLus in 12.2. There is a new “only” clause in the SET FEEDBACK command, so you can run queries but the resulting rows are not shown in the display. They are still…
12c Release 2 – Transparent Data Encryption online !
It doesn’t take a rocket scientist to know that even if you have incredibly stringent controls on user authentication, user authorisation etc, that wont save you if your data on disk is not encrypted. All you need is an errant tape, a missing disk,…
TimTams, Twelve Two, and tete-a-tete !
What do you do when you’re an Australian, you’re at Oracle Headquarters, 13,000 kms from home you bump into someone whilst grabbing a coffee Well…naturally, you lure them over with a packet of our famous Australian chocolate biscuits, grab a camera and have a…
Oracle Database 12c Release 2 is here !
Since OpenWorld 2016 when we first saw some of the cool features in Oracle Database 12c Release 2, many IT professionals out there have been exploring the release via our various cloud offerings, but if your organization has not yet embraced the cloud, then…
Extending Flashback Data Archive in 12c
Flashback Data Archive (previously called Total Recall) has been around for a long time now. For those unfamiliar with it, (and by the way, if you are on Enterprise Edition, you should be familiar with it, because its a free feature), here is a…
