(Oren Nakdimon) I have a table t and I want to add a unique constraint on one of its columns – c1.
Tag: Oracle
Installing PSU (GI+RAC+JVM)
(amitzil) I’ve installed quite a few PSUs in my professional life, but this time, it was something else. I’m talking about a RAC environment with 2 nodes and a database containing JVM, so this was a complex patch to begin with.
12c SQL loader express mode
(Mohamed Azar) In Oracle Database12c, SQL*Loader has a new feature called express mode that makes loading CSV files faster and easier.
12c DataGuard / Broker Pitfalls
(mdinh) In a broker configuration, you use the DGConnectIdentifer property to specify a connect identifier for each database.
Block-Related Oracle Rac Wait Events – Part 1
(Jagruti Jasleniya) The block-related wait event statistics indicate that a block was received as either the result of a 2-way or a 3-way message, that is, the block was sent from either the resource master requiring 1 message and 1 transfer, or was forwarded to a third node from which it was sent,
Dockerize Tomcat/Tom EE and Oracle database applications
(Debu Panda) Docker … Docker — everywhere ..
Publish Events from any Web Application in IFRAME to ADF Applications
(Lucas Jellema) Even though ADF does not always play nice with guests, it is becoming increasingly common to have ADF applications – pure ADF or WebCenter Portal – that are the host to embedded user interfaces, created in technologies such as Oracle JET, Vue.js, Angular or React. This is not the ide
Clone a table
(connormcdonald) Sometimes doing a CREATE TABLE AS SELECT is all we need to copy the data from an existing table. But what if we want more than that ? What if we really want to clone that table to match the original as closely as possible.
Can you use Oracle Database Unified Auditing with Oracle APEX?
(Joel R. Kallman) A customer asked me this morning: “Can we monitor the table access from an APEX application?”
Blocking Session not visible in v$ Views
(Martin) I had to troubleshoot an issue on a company ERP systems database, where several sessions were waiting for ‘enq: TX row lock contention’. It was a table containing print server nodes and this caused no more printouts.
