Uncategorized

ORA-65131 grrrr

Posted by

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 comments

  2. 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.

    Reply

Got some thoughts? Leave a comment

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

Gravatar
WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.