In this story, we are going to see what are the first steps after Installing Oracle in your computer.
[Optional] Set environment variable ORACLE_XE_HOME
You should be able to connect with Oracle as SYSTEM user on SQL Developer
You may want to see all the USERS automatically created by the Installer.
How to create a new user (without using C## prefix)
ALTER SESSION SET “_ORACLE_SCRIPT” = TRUE;
CREATE USER Anil IDENTIFIED BY anil123;
By default, newly created users will not be allowed to establish a connection with database.
If you try connect as Anil .. You will an error
GRANT the user to connect, play with resources (table, schema, etc) and DBA (administrator activities)
Connect as Anil
CREATE a Table called PRODUCT
As first steps after installing Oracle, now you have
- Created a New User
- Connected as the New User
- Created a Table
Oracle User: is a database account
Oracle Schema: is the User + User’s objects
User’s Objects: Table, View, Index, etc.
Thank you for reading this story !! … See you in Next Story :-)