Oracle Database 12c New Features Errata

This is the errata page for Oracle Database 12c New Features which can be found here.

From Terry Stough we have this correction:

On page 113, CONT_ID should be CON_ID. There are no CONT_ID columns in the database.

Thanks Terry!!

==================
27 January 2014 New Entry

A new entry. This is a great catch by Paul Alsemgeest that came to me by email. In it he notes that on Page 116 and 117 there seems to be a conflict. The graphic on 116 seems to indicate that a USERS tablespace is created in the CDB and on page 117 I say;

"The CDB has no user tablespaces or related datafiles".

However, if you look at a Oracle Database 12c Database you find the following:

SQL> select con_id, tablespace_name from cdb_tablespaces;

    CON_ID TABLESPACE_NAME
---------- ------------------------------
     0 SYSTEM
     0 SYSAUX
     0 UNDOTBS1
     0 TEMP
     0 USERS
     0 EXAMPLE

6 rows selected.
 Certainly I didn't create the USERS or EXAMPLE tablespaces. So what's up here?

I think the answer (which I have not yet verified but will when I can) is that when I wrote the chapters on Oracle Multitenant I had created two CDB's. One I created manually and one I created with DBCA. (actually throughout the writing I created many different CDB's but only one was done manually). I suspect that when i looked at cdb_tablespaces that I looked at the manually created CDB, and not one created by DBCA. I don't have that manual one around anymore, but when I can I'll test my theory.

DBCA creates a bunch of additional objects in the database that the create database command does not. The inclusion of the EXAMPLE tablespace above  indicates that I created this CDB with the sample schemas/data. This certainly would not be there with a manually created database unless I manually added them (which I would not have in this case).

At the end of the day though, regardless if there is a USERS tablespace, or any other non-Oracle system type of tablespace, the rule still applies. You really should not keep data in the CDB. Treat it like the root FS of a file system... keep it as clean as you can.

Thanks Paul

======================
New Correction from Byron...

On page 107, second paragraph, I say that you can downgrade to 11.2.0.7. This is obviously not the case since 11.2.0.7 does not exist. :) This should read 11.1.0.7, as seen in the bullet point just above the paragraph in question.

Thanks Byron!
======================