ORA-02381
cannot drop string profile
Cause
An attempt was made to drop PUBLIC_DEFAULT or a mandatory profile, which is not allowed due to following restrictions:
- PUBLIC_DEFAULT profile can be dropped only when the database is in migration mode.
- A mandatory profile can be dropped only if it is not set as a mandatory profile in root container (CDB$ROOT) of a multitenant container database (CDB) or in a Pluggable Database (PDB).
Action
If you are trying to drop the PUBLIC_DEFAULT profile, try dropping it during migration mode. If you are trying to drop a mandatory profile, check the MANDATORY_USER_PROFILE system parameter setting in the root container (CDB$ROOT) or in a Pluggable Database (PDB) and retry the operation after resetting the MANDATORY_USER_PROFILE system parameter by executing ALTER SYSTEM RESET DDL statement.
ORA-02381
cannot drop string profile
Cause
An attempt was made to drop PUBLIC_DEFAULT or a mandatory profile, which is not allowed due to following restrictions:
- PUBLIC_DEFAULT profile can be dropped only when the database is in migration mode.
- A mandatory profile can be dropped only if it is not set as a mandatory profile in root container (CDB$ROOT) of a multitenant container database (CDB) or in a Pluggable Database (PDB).
Action
If you are trying to drop the PUBLIC_DEFAULT profile, try dropping it during migration mode. If you are trying to drop a mandatory profile, check the MANDATORY_USER_PROFILE system parameter setting in the root container (CDB$ROOT) or in a Pluggable Database (PDB) and retry the operation after resetting the MANDATORY_USER_PROFILE system parameter by executing ALTER SYSTEM RESET DDL statement.
ORA-02381
cannot drop PUBLIC_DEFAULT profile
Cause
Try to drop PUBLIC_DEFAULT profile
Action
If you are trying to drop the PUBLIC_DEFAULT profile, try dropping it during migration mode. If you are trying to drop a mandatory profile, check the MANDATORY_USER_PROFILE system parameter setting in the root container (CDB$ROOT) or in a Pluggable Database (PDB) and retry the operation after resetting the MANDATORY_USER_PROFILE system parameter by executing ALTER SYSTEM RESET DDL statement.
