Skip to Main Content

Oracle Database Express Edition (XE)

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!

How to get started? Creating a user schema/user etc?

992146Sep 17 2023

Returning back to Oracle almost after 8 years and it seems everything is just changed.

C:\Windows\System32>sqlplus / AS sysdba
SQL*Plus: Release 21.0.0.0.0 - Production on Fri Aug 4 22:31:09 2023
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
XE

SQL> select name from v$pdbs;

NAME
--------------------------------------------------------------------------------
PDB$SEED
XEPDB1

Now watching this youtube video

But have no idea what to type after:

connect sys/oracle@

I just want to create a user/schema and some very basic tables into that. Nothing more than that. SQL Plus and SQL Developer is both installed and working fine.

Thanks in advance.

Comments
Post Details
Added on Sep 17 2023
1 comment
490 views