You can create a lot of constraints … 

tested in 12.2 You can create a lot of constraints ... create table aa (bbb varchar2(10) not null); Table created. alter table aa add (check (bbb is not null) enable validate); Table altered. alter table aa add (check (bbb is not null) enable validate); Table altered. alter table aa add (check (bbb is not null) enable … Continue reading You can create a lot of constraints … 

DBA role for anyone?

DBA role grant to myselft (tested in 12.2) thanks to Pete Finnigan  for explanation "this is not an exploit, this is due to the privileges granted" CREATE USER "TUSER" IDENTIFIED BY VALUES 'S:B368AC805D18763B7ABB524F49E264B5FB86C3A33574D41EEEEBCF96E08A;T:E1F2507A6EB276AF7C7C43FF1BBF5E BB31C5518EAA2E4F1EB1BB639D9B5A14C8D7AD4CF476D1C147C8869FE628963D2BA0C4808257D81DC81D5373CA2C3CAE739288D97C97F2D87E39069DB2E1F629DA' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; -- Note: No TS Quotas found! GRANT "CONNECT" TO "TUSER" GRANT "RESOURCE" TO "TUSER" GRANT … Continue reading DBA role for anyone?

Oracle 12.2 COLLATE BINARY_CI

1st db went online a week ago sofar so good Issues PL/SQL  compile 0/0 PL/SQL: Compilation unit analysis terminated 0/0 PLS-00761: Programmeinheitsortierung darf nur USING_NLS_COMP sein SQL> alter session set default_collation=USING_NLS_COMP;  Triggers An error in trigger PLS-00049: bad bind variable after converting tables to COLLATE BINARY_CI; SR will be created CREATE TABLE "CI"."TESTTAB" ( "ID" … Continue reading Oracle 12.2 COLLATE BINARY_CI