SQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 12 17:26:55 2020
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Enter user-name: system
Enter password:
Last Successful login time: Thu Mar 12 2020 17:19:39 +05:30
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL> select username from dba_users;
USERNAME
--------------------------------------------------------------------------------
SYS
SYSTEM
XS$NULL
OJVMSYS
LBACSYS
OUTLN
SYS$UMF
DBSNMP
APPQOSSYS
DBSFWUSER
GGSYS
USERNAME
--------------------------------------------------------------------------------
ANONYMOUS
CTXSYS
DVSYS
SI_INFORMTN_SCHEMA
DVF
GSMADMIN_INTERNAL
ORDPLUGINS
MDSYS
OLAPSYS
ORDDATA
XDB
USERNAME
--------------------------------------------------------------------------------
WMSYS
ORDSYS
GSMCATUSER
MDDATA
SYSBACKUP
REMOTE_SCHEDULER_AGENT
GSMUSER
SYSRAC
AUDSYS
DIP
SYSKM
USERNAME
--------------------------------------------------------------------------------
ORACLE_OCM
SYSDG
35 rows selected.
SQL> create user john identified by root
2 123
3
SQL> create user john identified by root
2
SQL>
Instructor
Priyanka Replied on 12/03/2020
You need to create user identified by the system's password through which you got connected with oracle. Have you used root as your password to get connected with oracle?
Hi Priyanka i tried with the password i gave for system.
Its not working.
Its better if i can share my desktop with with through skype.
Please let me know.
Instructor
Priyanka Replied on 13/03/2020
Kindly refer your mail_id so that i can connect with you through any other medium
lopamudra.mohapatra90@gmail.com
Instructor
Priyanka Replied on 14/03/2020
I will take a webex Meeting at 11 o'clock on Monday to solve this issue. I will send you the WebEx link on your mail ID