Australian readers will be pleased to note that, despite the Antipodean flavour of this post, there will be no mention of The Ashes. It is a well known fact that Kangaroos are not interested in cricket.
Recently after upgrading the dev database to 12c, I ran utlrp to compile the invalid objects and it failed with the below error
Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure that you are not hiding just a larger issue. It actually might represent either incorrect use of SQL or incorrect assumptions from the data model.
Consider the following example
SELECT DISTINCT d.dname
FROM emp e, dept d
WHERE e.ename = 'SMITH'
AND e.deptno = d.deptno
The query is certainly valid, but when I see "distinct" I ask myself the following questions:
Solution for the exercise posted at 13 August; the next reverse engineering exercise (for x86, ARM, ARM64, MIPS)
I was recently asked if we can move partition of one table into another? Basically a developers had truncated the partition and the team wanted to move the partition from one table to another.Both the table were structurally the same and had same data.
Here I will be showing how we can do that
1. Create a monthly partitioned table –
Sometimes I face a situation where the following command finishes successfully, however, RAC database ORACLE_HOME is not patched: [crayon-55e066230c2fe426841548/] There are 2 situations where this happens: 1. The GI home and RAC database home are under different Patch Sets (until 4th digit) i.e. : GI is 184.108.40.206 and RAC is 220.127.116.11 GI is 18.104.22.168 and …
Continue reading »
This Log Buffer Edition covers the top blog posts of the week from the Oracle, SQL Server and MySQL arenas.
An attempt to run OAM 11G Release 2 PS3 on Oracle Linux 6.7, WLS 12C, RDBMS 12C.
Pretty straightforward. Used Oracle 6.7, as 7 is not certified. Create a 200MB /boot, and an LVM for /, both ext4.
Install just the server. Deselect *all* options, just X system and X legacy support (the OUI needs it). Some 566 packages will get installed.
Make sure it boots, and the network starts.
I started my Oracle working life as a builder – a Forms & Reports Builder (briefly on SQL*Forms V2.3 but thankfully within a month or two we moved up to SQL*Forms V3, SQL*reportwriter V1.1 and SQL*Menu 5 – who remembers SQL*Menu?). Why were we called Builders? I guess as you could get a long way with those tools by drawing screens, utilising the (pretty much new) RI in the underlying Oracle V7 to enforce simple business rules and adding very simple triggers – theoretically not writing much in the way of code. It was deemed to be more like constructing stuff out of bits I guess.
When working with ORE you will end up creating a number of different data stores in the database. Also as your data science team increases the number of data stores can grow to a very large number. When you install Oracle R Enterprise you will get a number of views that are made available to ORE users to see what ORE Data stores they have and what objects exist in them. All using SQL. Perhaps some of the time the ORE developers and data analysts will use the set of ORE functions to manage the in-database ORE Data stores. These include: