PLEASE HELP FIX ERROR CODE IN PHOTO BELOW: You were just hired as a new junior Oracle
Question:
PLEASE HELP FIX ERROR CODE IN PHOTO BELOW:
You were just hired as a new junior Oracle database administrator (DBA) to assist a team of five senior database administrators. In your first week, you were handed the task of writing a script for creating database users(using SQL Developer or SQL Plus). The script will perform the following tasks and conform to the following specifications:
1. Create the following two (2) users with their respective passwords. Please use the exact spelling.
User Name | Password |
DBSEC | Tec5363%1 |
VPD_CLERK1 | Jessie#22 |
The following parameters apply to the above two (2) users.
2. The default table space is USERS.
3. The temporary table space is TEMP.
4. The user has to change his/her password the first time when he/she log in the database.
5. The user account will be assigned to the DEFAULT profile.
6. The USERS table space has a 30MB quota.
7. At the end of the creation, list the user information that shows a successful creation of the above user account.