Script for encrypted tablespace missing ENCRYPT keyword

Toad for Oracle - Beta
1

Howdy!

In 17.0.56.711 SB for tablespaces, I select a TS on the LHS. On the RHS Script tab, the resulting DDL is missing the ENCRYPT keyword:

CREATE TABLESPACE USERS
DATAFILE
  SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 32767M
LOGGING
ENCRYPTION USING 'AES256'
ONLINE
...

The keyword looks like it needs to be immediately after the tablespace encryption spec (USING 'AES256').

I didn't see any encryption settings in the script options...

Thanks!
Rich

2

Hi Rich,

Which Oracle version are you using? Toad just created this for me off an 18c DB. and it runs w/o any problems.

CREATE TABLESPACE ENCRYPT_TS2
DATAFILE 
  'F:\ORACLE\APP\CARYTOADSERVER\ORADATA\ORCL18\PDB1\USERS2_ENC01.DBF' SIZE 100M AUTOEXTEND OFF
LOGGING
ENCRYPTION USING '3DES168'
DEFAULT 
  TABLE COMPRESS FOR OLTP
  STORAGE (ENCRYPT)
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
3

Hey John!

My test TS doesn't have compression. The STORAGE (ENCRYPT) looks like it's dependent upon the compression tablespace option. If I change my "Compression" drop down in the RHS Script Options->Tablespaces from "Only when COMPRESS" to "Always", then I get the STORAGE clause.

Thoughts?

Thanks!
Rich

4

Ah, ok, I can reproduce the problem that way.

I'll have it fixed soon.

Thanks

1 Like