drop table COMP purgeORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create table COMP
( tstamp timestamp(6) not null,
empno number(10) not null,
ename varchar2(10) not null,
deptno varchar2(10) not null
)
PARTITION BY RANGE (TSTAMP)
SUBPARTITION BY LIST (deptno)
(
PARTITION p01 VALUES LESS THAN
(TIMESTAMP' 2010-01-01 00:00:00')
(SUBPARTITION p01_sp1 VALUES (1),
SUBPARTITION p01_sp2 VALUES (2),
SUBPARTITION p01_sp3 VALUES (3),
SUBPARTITION p01_sp4 VALUES (4)),
PARTITION p02 VALUES LESS THAN
(TIMESTAMP' 2010-02-01 00:00:00')
(SUBPARTITION p02_sp1 VALUES (1),
SUBPARTITION p02_sp2 VALUES (2),
SUBPARTITION p02_sp3 VALUES (3),
SUBPARTITION p02_sp4 VALUES (4)),
PARTITION p11 VALUES LESS THAN
(TIMESTAMP' 2010-11-01 00:00:00')
(SUBPARTITION p11_sp1 VALUES (1,2),
SUBPARTITION p11_sp2 VALUES (3,4)),
PARTITION p12 VALUES LESS THAN
(TIMESTAMP' 2010-12-01 00:00:00'),
PARTITION p13 VALUES LESS THAN
(TIMESTAMP' 2011-01-01 00:00:00')
)Table created.
select subpartition_name pname,
subpartition_position pos,
high_value
from USER_TAB_SUBPARTITIONS
where table_name = 'COMP'
order by 1,2| PNAME | POS | HIGH_VALUE | P01_SP1 | 1 | '1' | P01_SP2 | 2 | '2' | P01_SP3 | 3 | '3' | P01_SP4 | 4 | '4' | P02_SP1 | 1 | '1' | P02_SP2 | 2 | '2' | P02_SP3 | 3 | '3' | P02_SP4 | 4 | '4' | P11_SP1 | 1 | '1', '2' | P11_SP2 | 2 | '3', '4' | SYS_SUBP19912 | 1 | DEFAULT | SYS_SUBP19913 | 1 | DEFAULT |
|---|
drop table COMP purgeTable dropped.
create table COMP
( tstamp timestamp(6) not null,
empno number(10) not null,
ename varchar2(10) not null,
deptno varchar2(10) not null
)
PARTITION BY RANGE (TSTAMP)
SUBPARTITION BY LIST (deptno)
SUBPARTITION TEMPLATE
(SUBPARTITION d1 VALUES (1),
SUBPARTITION d2 VALUES (2),
SUBPARTITION d3 VALUES (3),
SUBPARTITION d4 VALUES (4))
(
PARTITION p01 VALUES LESS THAN
(TIMESTAMP' 2010-01-01 00:00:00'),
PARTITION p02 VALUES LESS THAN
(TIMESTAMP' 2010-02-01 00:00:00')
)Table created.
select partition_name pname,
partition_position pos,
high_value
from USER_TAB_PARTITIONS
where table_name = 'COMP'| PNAME | POS | HIGH_VALUE | P01 | 1 | TIMESTAMP' 2010-01-01 00:00:00' | P02 | 2 | TIMESTAMP' 2010-02-01 00:00:00' |
|---|
select subpartition_name pname,
subpartition_position pos,
high_value
from USER_TAB_SUBPARTITIONS
where table_name = 'COMP'
order by 1,2| PNAME | POS | HIGH_VALUE | P01_D1 | 1 | '1' | P01_D2 | 2 | '2' | P01_D3 | 3 | '3' | P01_D4 | 4 | '4' | P02_D1 | 1 | '1' | P02_D2 | 2 | '2' | P02_D3 | 3 | '3' | P02_D4 | 4 | '4' |
|---|