These are important
1. Create a tablespace and a temporary tablespace
Create tablespace <Name> datafile '<path> 'size <x> m
Create temporary tablespace <Name> tempfile' <path> 'size <x> m
Example:
Create tablespace test datafile 'd:/Oracle/product/10.2.0/oradata/orcl/test. dbf' size 50 m;
Create temporary tablespace test_temp tempfile 'd:/Oracle/product/10.2.0/oradata/orcl/test_temp.dbf 'size 50 m;
2. Create a user
Create user <username> identified by <password>
Example: create user Andy identified by Andy
3. Assign Permissions
Grant <permission 1, permission 2...> to <user>
Grant crate session, DBA to Andy
4. Unlock the locking user
Alter user <username> account <lock | unlock>
Alter user Andy account lock
Alter user Andy account unlock
5. Change the password
Alter user <username> identified <password>
Alter user Andy identified cool
Note: Each user can use this command and DBA can change to any user.
6. delete a user
Drop user <username> [cascade]
Drop user Andy Cascade
Note: If you have created a table, you must use cascade.
7. Allocate user tablespace and temporary tablespace
Alter user <username> default tablespace <spacename> temporary tablespace <spacename>
Alter user Andy default tablespace test temporary tablespace test_temp
8. Create a data table in the tablespace
Create Table <Name> ([<columnname1 type1> constrant...) tablespace <Name>
Create Table Table1 (col1 INT) tablespace Test
