In moving some more code from an 11gR2 database to a 12cR2 database, I found another change where a piece of code that works in 11gR2 doesn’t compile in 12cR2.
In this instance a view was being created with a projected date column which used the ANSI DATE syntax. Here is a simplified test script:
CREATE OR REPLACE VIEW test1 AS
SELECT date '0000-01-01' date_col
DROP VIEW test
CREATE OR REPLACE (more...)
I encountered an issue today trying to create a table in an Oracle 12cR2 database, the DDL for which, I extracted from an Oracle 11gR2 database. The error returned when trying to create the table was:
ORA-54002: only pure functions can be specified in a virtual column expression
The definition of the table included a Virtual Column which used a REGEXP_REPLACE call to derive a value from another column on the table.
Here is a simplified (more...)
Obviously nobody could beat Tim to getting the comprehensive installation instructions out first, but here are my notes for installing it on a proxmox container environment which is what I use as my research platform. Some of the calls used are from or based on Tim’s prior 12cR1 installation article – thanks Tim.
NOTE – this post is just a guide and is based on my environment – you will likely need to make changes to (more...)