python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - subpartition

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, s...
test-img

dbspecialist

oracle

split

partitioning

subpartition

Votes: 0

Answers: 1

Latest Answer

List partitioning by timestamp??? SQL> create table mytable(   2                       load_dts    timestamp(6) not null,   3                       segment     VARCHAR2(4000),   4                 ...
test-img

Pugzly

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 sin...
test-img

Logan

sql

database

database-partitioning

sql-drop

subpartition

Votes: 0

Answers: 1

Latest Answer

If the partition contains only one subpartition, you can drop the partition instead. R
test-img

Rownum Highart

Posts

Questions

Blogs

Jobs