N
N
Nikolay Baranenko2017-08-11 06:04:34
Oracle
Nikolay Baranenko, 2017-08-11 06:04:34

How to remove old partitions?

Hello.
checked user objects

select uo.*/*, t.rowid*/
     from user_objects uo

and found old partitions to the table that was recreated
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

How to remove these old partitions?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Eugene, 2017-08-11
@drno-reg

I highly recommend that you get started with ORACLE by reading the basic concepts.
https://docs.oracle.com/database/121/CNCPT/toc.htm
In particular, read about the basket there. Objects are removed from it with the PURGE command.
PURGE RECYCLEBIN;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question