How To Connect To SCHEMA's Where Password Is Not Known

(Doc ID 2412878.1)

Last updated on JULY 01, 2018

Applies to:

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

Goal

How to be able to connect to the SCHEMA and DROP TABLES and OBJECTS without knowing the password. 

Some are service accounts and if the password is changed something may not work anymore. i.e. Datapump EXPORT and IMPORT.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms