I am not going to post how to convert to extended data type since there are many blogs on that already.
Just a reminder, there’s no going back; hence have backup and possibly minimize changes during testing to be able to restore (which is ideal and may not be feasible).
Before reverting to MAX_STRING_SIZE=STANDARD, columns affected by extended data type need to be identified.
From Oracle documentation, MAX_STRING_SIZE controls the maximum size of VARCHAR2, NVARCHAR2, (more...)
this third and last part of a three part series on subprocesses we will
explore a special type of subprocess referred to as an “Event”
This type of subprocess is triggered by an event that
can occur anytime during the execution of a process flow that allows you
to interrupt the normal flow of an instance.
Such capability can be
applicable in various use cases. For example, an error might occur in
up a series of questions around setting timers in the Oracle Community
forums, I decided to write this article to try and guide their use and
how these can be used to control process execution.
The Use Case
We’ll begin by setting up the scenario in which we’ll have to control our process flow.
that you want to have a part of your process that executes immediately
if the current time (more...)
This is a series of 8 short videos explaining how to create a
BPM application using Oracle Process Cloud Services. Part 1 will show
how to login and create a new application:
SOA & BPM Partner Community
regular information (more...)
In my post on the differences between ADD TRANDATA and ADD SCHEMATRANDATA, I highlighted the differences between the two ways of adding supplemental logging to tables. One of the things I pointed out was that ADD SCHEMATRANDATA doesn’t add any supplemental log groups (SLG). Without SLGs then how does ADD SCHEMATRANDATA work? That was the question I was left with. So I started digging around to find the answer and I think you may be (more...)
Since I published posts on how to retrieve command history within GGSCI using the Oracle provided commands of “history” and “fc”, I was pinged a couple of times by some friends asking about “rlwrap” usage with GoldenGate. The answer is a simple yes, rlwrap can be used with Oracle GoldenGate.
What exactly is “rlwrap”?
According to the readme file at http://utopia.knoware.nl/~hlub/uck/rlwrap/#rlwrap, rlwrap is a ‘read-one wrapper’. (more...)
Ever get tired of typing the same command over and over again in Oracle GoldenGate GGSCI? Well, Oracle has provided a history recall function into GGSCI, I talked about his in an earlier post. This post on history recall can be found here.
In this post, lets take the command recall and how these commands can be edited. In Oracle GoldenGate 12c, Oracle has provided an GGSCI command called “FC”. The “FC” command is used (more...)
If you are familiar with using Oracle GoldenGate, you know that on the source side of the equation you have to enable supplemental logging and sometimes force logging on the database. I traditionally do both just to make sure that I capture as much as I can into the redo stream from the transactions on the database. For Oracle GoldenGate purposes, this is not the only thing you need to turn on to ensure all (more...)
The team often fields
questions about the upgrade process between versions – and here we have a case
study from a customer who has recently gone through that process. Do you like to fly safely?
is the European organization for the safety of air navigation and consists of
41 member states. It manages the air traffic network, route charging, and
working with other organizations to (more...)
In Part I, we looked at how you can now store JSON documents within the Oracle 12c Database. For efficient accesses to JSON documents stored in the Oracle database, we can either create a function-based index based on the JSON_VALUE function or on JSON .dot notation. These indexes are useful for indexing specific JSON attributes, […]
So you run a query and it gives you a plan with a note that says “This is an adaptive plan”.
So you run it again and the plan changes, with a note that says “Statistics feedback used for this statement”
So you pause to think for a bit, then run the query again and the plan changes, with a note that says “One SQL Directive used, dynamic statistics used”. (You waited too long and (more...)
I don’t know but best to have one.
With multi-tenant database, I would use OMF to keep it simple and to avoid having to remember about FILE_NAME_CONVERT.
When creating PDB, there may be specification for ADMIN USER as show below:
CREATE PLUGGABLE DATABASE april ADMIN USER april_admin IDENTIFIED BY oracle;
Here are some examples I have come across (Names and Blogs are not provided to protect the innocents):
create pluggable database PDB1 admin user pdb1_admin
Oracle has recently released version 126.96.36.199.0 for OBIEE 12c, which has a variety of exciting new features for Data Visualization, BI Publisher, Dashboards in OBIEE, and ODBC connections. It can be performed as an in-place upgrade (performed by the Upgrade Assistant) or as a fresh install. The upgrade process is explained at length here. There is also an example Linux in-place upgrade from 188.8.131.52 to 184.108.40.206 which (more...)
1.8 Details of Support for Objects and Operations in Oracle DDL
The following tables are excluded by default.
"*.AQ$*", // advanced queues
"*.DR$*$*", // oracle text
"*.M*_*$$", // Spatial index
"*.MLOG$*", // materialized views
"*.OGG$*", // AQ OGG queue table
"*.ET$*", // Data Pump external tables
"*.RUPD$*", // materialized views
"*.SYS_C*", // constraints
"*.MDR*_*$", // Spatial Sequence and Table
Since the release of OBIEE 12c in 2015, we have received countless inquiries about how we would be offering our training. Our customers are familiar with our ability to provide on-site private training for a team and we are well known for hosting training classes in our offices in the UK and the US. But what most people aren’t aware of is that we now offer OBI remote training.
Our public training schedule offers a (more...)
Recently at Rittman Mead we have been asked a lot of questions surrounding Oracle’s new Data Visualization Desktop tool and how it integrates with OBIEE. Rather than referring people to the Oracle docs on DVD, I decided to share with you my experience connecting to an OBIEE 12c instance and take you through some of the things I learned through the process.
In a previous blog, I went though database connections with Data Visualization (more...)
I have followed the steps in Oracle Documentation link: https://docs.oracle.com/cd/E63000_01/EMXIG/ch2_deployment.htm#EMXIG215 to configure Exadata Database Machine in OEM13c. If you want to configure your Exadata in OEM13c you have to follow the above mentioned link. In this post I will share the mandatory steps for configuration, and some of the issues which I faced while configuring the Exadata…
At this Wednesday’s Oracle Midlands event someone asked me if Oracle would use the statistics on invisible indexes for the index sanity check. I answered that there had been a bug in the very early days of invisible indexes when the distinct_key statistic on the index could be used even though the index itself would not be considered as a candidate in the plan (and the invisible index is still used to avoid foreign key (more...)
Use of ANSI SQL is a personal thing.
Historically I have not been a fan apart from where it makes things easier/possible.
This reticence was mainly due to optimizer bugs and limitations in the earlier days.
Recently I have been using it much more because I find that the developers I interact with prefer it / understand it better.
You might/should be aware that Oracle will rewrite ANSI SQL to an Oracle syntax representation, this (more...)