Subpartition issues

Toad for Oracle & DevOps Toolkit
1

Toad 2025 r1
have a simple table with hash partitioned and list subpartitions,

1/I cannot see way to generate script for this table including subpartition template.
2/While modifying subpartition template no code (Show SQL) is generated until I provide different change in partitionning (for example modifying partition name) - message "No changes have been made" is displayed, only consecutive button press (Show SQL) gets code generated.
3/

2

Please provide the script for your table so I can reproduce this.

If you don't have the original script, run this with F9 in the Editor, using your table name instead of EMP, of course:

select dbms_metadata.get_ddl('TABLE', 'EMP') from dual;

3

John I used following table:

CREATE TABLE tp1 (
  id               NUMBER,
  country_code     VARCHAR2(3),
  record_type      VARCHAR2(5),
  descriptions     VARCHAR2(50),
  CONSTRAINT t1_pk PRIMARY KEY (id)
)
PARTITION BY HASH( id )
subpartition  BY LIST (country_code, record_type) 
subpartition template
(
  subPARTITION part_gbr_abc VALUES (('GBR','A'), ('GBR','B'), ('GBR','C')),
  subPARTITION part_ire_ab  VALUES (('IRE','A'), ('IRE','B')),
  subPARTITION part_usa_a   VALUES (('USA','A'))
 )
  PARTITIONS 4;

Then I tried to add  like a separate subpartition for  ('USA','Z')
4

Thanks.

I am able to reproduce the first problem, where the script is missing the subpartition template. But when I go into the "alter table" window, I can add another item to the template and the script appears on the first try.

To be honest, I wasn't aware that Oracle allowed hash-list partitioning. Toad's Create Table window won't let you create a table like that.

I'll get the script and create table window fixed today. If I can figure out what's up with your USA/Z subpart, I'll fix that too.

5

I was able to reproduce the bug where USA/Z didn't show up the first time.

Easier workaround is to just click on a different row in the grid after adding a new row, then click Show SQL. This posts it to the grid. You shouldn't have to do that - Toad should do it automatically. I'll fix that too.

Thanks for reporting these issues. They will be fixed in the next beta.