(James Coyle) I bumped into this issue recently which prevents you INSERTING a date of 31-12-9999 into an INTERVAL partitioned table due to the fact that the LESS THAN partition value would be larger than an Oracle Date.

(stewashton) We very often make spreadsheets with subtotals for each row and for each column. Someone on the OTN forum asked how to produce data in this format. I answered using the cool CUBE function.

(Andrejus Baranovskis) This post is based on JDEV 12.2.1.1, it seems like there is issue with ADF BC REST custom method definition in this release. I’m glad it is not runtime issue, but related to design time JDEV wizard incorrect functionality.

(Randolf Geist) The next part of the video tutorial explaining the XPLAN_ASH Active Session History functionality continuing the actual walk-through of the script output.

(mdinh) I have never delved into networking for GoldenGate since things just work. Due to security tightening, telnet is no longer available to verify opened port.

(Martien van den Akker) I have encountered several times in WebLogic 12c that when the ConnectionPool of a DataSource in WebLogic could not be initialized because due to a connection error or invalid username or password, the server could not be started.

(David Fitzjarrell) In my previous article an issue was discussed that Oracle Support declared as a bug. Further investigation indicates this is not a bug but expected behavior for locally managed tablespaces with system-managed extents, which is why no solution or workaround has been posted as of n

(Gleb Otochkin) We use the terms DDL and DML in our DBA life with Oracle all the time. The first stands for Data Definition Language and it is about Data Definition changes. The latter is about manipulation with your data itself, and stands for Data Manipulation Language.

(James Coyle) You may have seen the below error when using dates at the extremes with an Oracle Database. This post focuses on the scenario where you’re inserting a high date, such as 31-12-9999 into an INTERVAL partitioned table.

(David Fitzjarrell) Someone in one of the Oracle forums asked the following question: