Data Base Oracle Common commands

Data Base Oracle Common commands

1. Login: (no password required, administrator rights)

Conn/as SYSDBA

2. View the database storage location:

Select name from v$datafile;

3. Create TABLE spaces:

Syntax:create tablespace tablespace name datafile ' data file path ' size;

Example:create tablespace test_db datafile ' D:\ORACLE\ORADATA\ORCL\test_db.dbf ' size 3000m;  

4. Create a User:

Syntax:create user username identified by password default tablespace which table space is used by the user;

Example:Create User test_db identified by test_db default tablespace test_db;

5. Change Password:

6. Unlock:

7. Add Lock:

8. Authorization:

syntax: grant  role 1, role 2  to  user name;   

Example:Grant DBA, connect to test_db;

Data Base Oracle Common commands