Rekeying

You can change (rekey) a master key and table keys. You cannot rekey tablespace keys.

Getting ready

It is assumed that a keystore is opened and a master key is created.

Connect to the database as a user who has administer key privilege or SYSKM privilege (for example, maja):
```
$ sqlplus maja
```
To rekey a table (for example, the oe.customer) using a different encryption algorithm (for example, AES128), execute the following statement:
Figure 24 - Rekeying a table key
Change a master key by executing the following statement (in our example, keystore_password is welcome1):
```
SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY keystore_password ...
```

Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.