ORA-65131 grrrr

So…the future is container databases ?

Cool ! I’ll create all my databases as container databases….I’m so happy….until

SQL> CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH;
CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH
*
ERROR at line 1:
ORA-65131: The feature Flashback Data Archive  is not supported in a pluggable database.

It is documented but seriously….that’s not so flash :-)

2 thoughts on “ORA-65131 grrrr

  1. It does seem intuitive that some operations on 12c such as archive logging and flashback only apply to the physical database (CDB or non-CDB). The main issue with PDBs as I see it is in the licensing. Any PDBs after the first are not free. Whereas extra instances on the same host using the same Oracle version require no extra licenses. It makes PDBs look like a disingenuous ploy to increase the Oracle revenue stream. If I were still a practising DBA I would create each CDB with just one PDB inside. You’d get most of the benefits of PDBs without paying extra.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s