Questions tagged [subpartition]
6 questions
1
vote
0 answers
ORA-12842: Cursor invalidated during parallel execution error during alter table move subpartition
Had a task to compress some large tables to reduce storage costs by using Oracle's Advanced Compression. Here is the statement :
execute immediate 'ALTER TABLE ' || i_table_name || '
MOVE SUBPARTITION '|| i_sub_part_name…
Sherzodbek
- 170
- 1
- 20
0
votes
1 answer
Moving values from default subpartition
in an oracle 19c database, on a key value table I've defined a partition on the load timestamp and subpartitions on custom sets of columns.
create table mytable
(
load_Dts timestamp(6) not null,
segment VARCHAR2(4000),
field_ident…
dbspecialist
- 13
- 4
0
votes
1 answer
How Drop the only subpartition of a partition
While I am deleting subpartitions, one of the partition contains only one subpartition I got an error.
Error: ORA-14629 cannot drop the only subpartition of a partition
Can anyone know how to drop single subpartition of a partition
Logan
- 13
- 2
0
votes
1 answer
Automation Script to maintain Oracle Table Subpartitions
I am new to PLSQL.
Can someone please provide me automation script to maintain(drop and create) subpartition in the Oracle table.
I know the script to maintain the table partition but unable to frame for Subpartitions.
Some details:
Range-Range…
Pankaj
- 1
- 2
0
votes
0 answers
Oracle partitions and sub-partitions
Currently, we use a query similar to the following to add partitions:
ALTER TABLE ${" + DDL_VARIABLE_KEY_SCHEMA_NAME + "}.${" +
DDL_VARIABLE_KEY_TABLE_NAME + "} ADD PARTITION ${" +
DDL_VARIABLE_KEY_PARTITION_NAME + "} VALUES LESS THAN(${" +
…
Dothertechie
- 27
- 6
0
votes
2 answers
Find all Subpartition name
The Table was subpartitioned based on column(INSTANCE) who's value can be '1' or '2'. Want to list all subpartition name which contains INSTANCE value as '2'
select * from user_tab_subpartitions sp where table_name='TEST' and sp.NUM_ROWS >0
and…
upog
- 4,965
- 8
- 42
- 81