Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01918: user 'SCOTT' does not exist

happy10319Nov 27 2018 — edited Dec 1 2018

Hi,

On 12C on Oracle linux

sqlplus sys@CONT as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 27 22:16:02 2018

Enter password:

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PLUG1 READ WRITE NO

4 PLUG2 MOUNTED

SQL> select username, common, con_id from cdb_users where username like '%SCO%';

USERNAME

--------------------------------------------------------------------------------

COM CON_ID

--- ----------

SCOTT

YES 1

SQL> alter user SCOTT identified by tiger;

alter user SCOTT identified by tiger

ERROR at line 1:

ORA-65048: error encountered when processing the current DDL statement in

pluggable database PLUG1

ORA-01918: user 'SCOTT' does not exist

Why this error?

Thanks.

This post has been answered by Bhavani Dhulipalla on Nov 27 2018

Jump to Answer

Added on Nov 27 2018

#general-database-discussions

8 comments

4,047 views