Question: In this exercise, you will create some users to be used for the remaining exercises in this chapter. It is assumed that there is a
In this exercise, you will create some users to be used for the remaining exercises in this chapter. It is assumed that there is a permanent tablespace called EXAMPLE and a temporary tablespace called TEMP. If these dont exist, either create them or use any other suitable tablespaces. Here are the steps to follow:
1. Connect to your database with SQL*Plus as a highly privileged user, such as SYSTEM or SYS.
2. Create three users:
create user alois identified by alois default tablespace example password expire;
create user afra identified by oracle default tablespace example quota unlimited on example;
create user anja identified by oracle;
***Book** OCA Oracle database 12c installation and administration
*** I need to see your sql plus screen shot
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
