Oracle creates and authorizes users in PLSQL

1. Open SQL Plus and enter the user name and password as prompted.

Note: If you are a system user, you can only log on with sysdba. For example: sys as sysdba, enter the User password to log on.

2. After logon, create a tablespace. Here, my tablespace is "StationSpace ".

Create TableSpace StationSpace DataFile 'e: \ Oracle \ oradata \ StationSpace. dbf' Size 1024 M Uniform Size 128 k;

3. After the tablespace is created successfully, create a user.

Create User UserName Identified by Password Default TableSpace StationSpace;

4. After the user is created, the user can be authorized.

Grant Connect, Resource, DBA to UserName;

After Oracle 10g is installed, restart the system. If PLSQL is used for connection, no listening is reported.

ORA-03114 PLSQL process compilation disconnection Error

Simple configuration of PLSQL connection to Oracle

Detailed description on Performance Improvement of PLSQL batch Forall operations

Use Oracle SQLDeveloper to connect to the database and create a user

Oracle PL/SQL Developer import and export data

Install the Oracle 11g and Oracle SQL Developer clients in 64-bit Windows 7