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 FROM dual / DROP VIEW test / CREATE OR REPLACE (more...)
Oracle WebLogic Server 12c is a part of the Oracle Fusion Middleware 12c line of offerings, which consist of several Oracle products that span content management, integration services, collaboration tools and business intelligence.
Products like Oracle Fusion applications and Oracle SOA rely on Oracle WebLogic Server to run their code.
The Oracle WebLogic Server 12c is easy to install; however, administrators need to know the following:
- Which tasks they will (more...)
A couple of articles have crept out over the last few days that relate to online operations on Oracle Database 12c Release 2 (12.2). Both of them are pretty small in terms of what you have to do, but are pretty awesome in terms of impact, so I’m giving them the official thumbs-up!
The first one is about moving tables online.
One of the biggest things that we couldn’t do in the previous versions of the oracle database was to use the back arrow button-to reexecute the old commands, without typing them. Of course, a workarouns is possible in the form of rlwrap but it’s not comparable to a natively available feature in the SQL*PLUS. Well, until now because now, we have HISTORY option available in 12.2 SQL*PLUS. Let’s take a look.
Three Oracle courses in particular will help you get started on Oracle Database 12c:
The Oracle Database 12c R1: New Features for Administrators training will provide you with up-front information about (more...)
This probably applies to other versions as well.
Don’t you love it when there’s a simple solution?
oracle@test1:/opt/oracle/12.2.0/ggs01$ ggsci Oracle GoldenGate Command Interpreter for Oracle Version 188.8.131.52.170221 OGGCORE_184.108.40.206.0OGGBP_PLATFORMS_170123.1033_FBO Linux, x64, 64bit (optimized), Oracle 11g on Jan 23 2017 21:54:15 Operating system character set identified as UTF-8. Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved. GGSCI (test1) 1> create subdirs Creating subdirectories (more...)
Recently I was asked to create a simple Master-Detail Apex form on top of some metadata tables stored within Oracle 12c. Apex version 4.2 is already pre-installed in 12c but it needs configuring to be able to use. This is where I hit some trouble which stems from a conflict of information across a number of different sources.
I was following the Oracle certified documentation on 4.2 and how to get it running (more...)
View this message in a Web browser
I was troubleshooting an issue where the Oracle Database Result Cache did not get used when the RESULT_CACHE hint was specified inside a subquery. As the main query has a sysdate inside, the RESULT_CACHE Hint can not be specified for the main query, but only for the subquery.
SELECT SQ.*, sysdate FROM (SELECT * FROM tableX, ....) SQ;
When using “/*+ RESULT_CACHE */ inside of Subquery, result cache was not (more...)
Recently I have had an issue with slow unicode migration of the database upgraded from 10g to 220.127.116.11. The main problem was a table with xmltype: we spent about 4 hours for this table(~17GB) during test migration, though all other tables (~190GB) migrated just for about 20 minutes.
We used DMU(Database Migration Assistant for Unicode), and the root cause of the problem was update statement generated by DMU for this table: