Tag: 12c

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…

Man…I really really like this :-)

Yeah yeah, you can argue with me about backward compatibility, but I’m so glad someone snuck this into 12c… 11.2 SQL> grant resource, connect to demo identified by demo; Grant succeeded. SQL> select privilege 2 from dba_sys_privs 3 where grantee = ‘DEMO’; PRIVILEGE —————————————-…

12c FETCH FIRST

Tom Kyte’s latest magazine article talks about the new FETCH FIRST syntax in 12c. You can read about that at: http://www.oracle.com/technetwork/issue-archive/2013/13-sep/o53asktom-1999186.html There’s a (quite valid) comment at the end of the article: “Note that in real life, you would use bind variables instead of…

12c invisible columns

As several bloggers have already pointed out, column order changes when you start playing with invisible columns, for example SQL> create table T ( c1 int, c2 int, c3 int ); Table created. SQL> desc T Name Null? Type —————————————– ——– ————— C1 NUMBER(38)…

12c ddl logging

In new releases, its often the little things that really catch my attention. Like this one…. I love it SQL> alter system set enable_ddl_logging = true; System altered. SQL> create table t ( x int ); Table created. SQL> drop table t purge; Table…

12c install on Windows

This is not a complete how-to, because I do not think its warranted…you pretty much click Next Next Next (which in itself is a credit to the product) But one thing to note – on the few machines I’ve installed it on, the installer…

Feeling raw about raw…

Its been well documented for a while that Oracle were not going to allow raw devices in 12….but this still seems brutal. 8.1.12 Desupport for Raw Storage Devices Starting with Oracle Database 12c, block file storage on raw devices is not supported. You must…