Answer the question
In order to leave comments, you need to log in
How to remove old partitions?
Hello.
checked user objects
select uo.*/*, t.rowid*/
from user_objects uo
OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME SHARING EDITIONABLE ORACLE_MAINTAINED APPLICATION DEFAULT_COLLATION DUPLICATED SHARDED CREATED_APPID CREATED_VSNID MODIFIED_APPID MODIFIED_VSNID
1 BIN$Vme0vmyDQAzgVQoAJ2HgqQ==$0 UM_TASKS_PARTITION_BY_ID_1 73864 73864 TABLE PARTITION 11.08.2017 5:42:48 11.08.2017 5:42:48 2017-08-11:05:42:48 VALID N N N 1 NONE N N N N
11 BIN$Vme0vmySQAzgVQoAJ2HgqQ==$0 UM_TASKS_PARTITION_BY_ID_1 73873 73873 TABLE PARTITION 11.08.2017 5:47:35 11.08.2017 5:47:35 2017-08-11:05:47:35 VALID N N N 1 NONE N N N N
12 BIN$Vme0vmyWQAzgVQoAJ2HgqQ==$0 UM_TASKS_PARTITION_BY_ID_1 73877 73877 TABLE PARTITION 11.08.2017 5:52:13 11.08.2017 5:52:13 2017-08-11:05:52:13 VALID N N N 1 NONE N N N N
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question