Oracle 21C, new feature blockchain tables.

Posted on January 20, 2021 by rlockard

I’ve spoken in the past about the utility of blockchain, to create a table that can not be altered. Oracle 21C is now available in OCI.

The syntax to create a blockchain table is quite simple.

create blockchain table test (x number)
                     NO DROP UNTIL 30 DAYS IDLE
                     NO DELETE LOCKED
                     HASHING USING "SHA2_512" VERSION "v1";

The addition of the blockchain keyword, the options no drop until <>, no delete, locked, and specifying the hashing algorithm and version.

This entry was posted in infosec. Bookmark the permalink.

Leave a Reply