id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
35334	Update Oracle backend supports_sequence_reset = True	David Sanders	Anmol Multani	"The Oracle backend currently specifies `supports_sequence_reset = False`. It looks as though it's been this way since the flag was added to the Oracle backend since https://github.com/django/django/commit/0df4593f0ed.

This commit appears to have been for the 1.5 release [1] which was released in Feb 2013. A few months later Oracle 12.1 [2] was released in July 2013. It's quite hard to determine when `ALTER SEQUENCE … RESTART` support was introduced but from some pain-staking searching I found that apparently 12.1 included support for it but it wasn't documented until 18c [3]:

> There is a new option for altering a sequence that appeared in 12.1 but was not documented until 18c:
> `alter SEQUENCE [schema_name.]{sequence_name} restart;`


[1] https://docs.djangoproject.com/en/5.0/releases/1.5/
[2] https://en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions
[3] https://www.red-gate.com/simple-talk/databases/oracle-databases/oracle-sequences-12c-features-including-identity/"	Cleanup/optimization	assigned	Database layer (models, ORM)	5.0	Normal				Accepted	0	0	0	0	0	0