My Oracle Support Banner

Seeded Database Account Called DIP was Accidentally Dropped. What is the Impact on the Database? What is the Purpose for DIP DB Account / DIP Schema, and How to Recreate it? (Doc ID 1987705.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Internet Directory - Version 9.0.4 to 11.1.1 [Release 10gR1 to 11g]
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


The Oracle Internet Directory (OID) component is not being used in the system.

There is an Oracle predefined / seeded account called DIP in each database (DB) that was accidentally dropped using the drop user command, which dropped the DIP userID (drop user DIP cascade;).

Is there any impact on the database?

And if wanting to recreate the account back (as Oracle suggests not to delete/drop any predefined account), what is the proper process to do so?


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.