Follow the instructions below to set up the Oracle database.
...
3. As SYS DBA, create a database user and grant privileges to the user as shown below:
Code Block | ||
---|---|---|
| ||
Create user USER_NAME identified by PASSWORD account unlock; grant connect, resource to USER_NAME; grantwith create session, dba to USER_NAMEadmin option; commit; |
For example,
4. Exit from the SQL*Plus session by typing the "quit" command.
...
Info |
---|
When using the if it is necessary to set this property permanently, then it should be defined inside the |
Create Database Tables
Database tables can be created either manually by running scripts or automatically by using start-up parameters.
...