Learning is not a spectator sport

January 18, 2014

ORA-65131 grrrr

Filed under: Uncategorized — connormcdonald @ 4:21 pm

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 :-)

About these ads

2 Comments »

  1. Typical Oracle half-baked feature implementation. I much prefer using Postgres these days.

    Comment by Colin 't Hart — January 18, 2014 @ 4:39 pm

  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.

    Comment by Martin FitzGerald — February 17, 2014 @ 10:13 pm


RSS feed for comments on this post. TrackBack URI

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

The WordPress Classic Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 80 other followers

%d bloggers like this: