create table pa(p number constraint pa_pk primary key) partition by hash(p) partitions 2; select partition_name from user_tab_partitions where table_name = 'PA'; SYS_P61 SYS_P62
Truncating a partition with Toad gives an error.
alter table pa truncate partition SYS_P61; ORA-14006: invalid partition name
Modifying index visibility with Toad gives an error.
alter index pa_pk invisible; ORA-14141: ALTER INDEX VISIBLE|INVISIBLE may not be combined with other operations alter index pa_pk visible; ORA-14141: ALTER INDEX VISIBLE|INVISIBLE may not be combined with other operationsJust get rid of the semi colon and you are able to use these commands with Toad.
alter index pa_pk visible