(Andrew Reid) I exported 3 large tables from an Oracle 11.2.0.4.0 database then tried to import them into an Oracle 11.1.0.6.0 database but the impdp failed as follows:
Tag: Oracle
SQLcl: Using the new CTAS Command
(Jeff Smith) How often do you need to build a new table to test something out?
AUDIT_SYS_OPERATIONS defaults to TRUE in #Oracle 12c
(Uwe Hesse) A small but remarkable change in Oracle Database 12c is the default value of AUDIT_SYS_OPERATIONS has changed to TRUE now. In other words, all actions done by the superuser sys are being audited now by default!
ORA-39001, ORA-39000 and ORA-39142
(Andrew Reid) I exported 3 large tables from an Oracle 11.2.0.4.0 database then tried to import them into an Oracle 11.1.0.6.0 database but the impdp failed as follows:
ORA-15410: Disks in disk group do not have equal size
(Alex Fatkulin) 12.1.0.2 ASM introduced a new feature which might prevent you from adding dissimilar size disks into a normal or high redundancy disk groups. The relevant MOS note is Doc ID 1938950.1.
Oracle Management Database in Grid Infrastructure: -MGMTDB
(Neil Chandler) Why? Why is is now mandatory to have the cluster management database as an Oracle CDB, with a PDB having the same name as the cluster?
Oracle 12 and latches, part 2
(Frits Hoogland) In my previous post, I looked at non shared latches and how the latching is done by Oracle. This post is a description on how the latching works for shared latches.
ORA-15410: Disks in disk group do not have equal size
(Alex Fatkulin) 12.1.0.2 ASM introduced a new feature which might prevent you from adding dissimilar size disks into a normal or high redundancy disk groups. The relevant MOS note is Doc ID 1938950.1.
Oracle Management Database in Grid Infrastructure: -MGMTDB
(Neil Chandler) Why? Why is is now mandatory to have the cluster management database as an Oracle CDB, with a PDB having the same name as the cluster?
Oracle 12 and latches, part 2
(Frits Hoogland) In my previous post, I looked at non shared latches and how the latching is done by Oracle. This post is a description on how the latching works for shared latches.
