How to drop duplicate "sys" User from the database (Doc ID 2787682.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and later
Information in this document applies to any platform.

Delete duplicate sys user name entry in the database?

SQL> select username, user_id, CREATED from dba_users where username in ('SYS','sys');

USERNAME USER_ID CREATED
-------------------- ---------- ---------
SYS 0 17-APR-19
sys 107 28-JUN-21 <<<<<

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.