Oracle installation: Merging two files
Global Users: Achievec
Password: Admin123456
Users: Scott
Password: Tiger
Oracle Development tools:
- SQLPLUSW and sqlplus and PL/SQL developer
Oracle directives:
- Conn[ect] Username/password @ network [as Sysdba/as Sysoper]
- Show user
- Disc[onnect]
- Exit//Disconnect and exit Sqlplus
- Passw[ord] XXXXX//Modify your password, or modify another user's password under SYS or system permissions;
- Created by: Create user xxx identified by xxx
- Create a user's authorization: Grant create session to XXXX
- Reclaim permissions: Revoke permissions from XXX
- Delete users: Drop user xxxx [cascade]//If there is a slip-on table, use Cascade to delete the Cascaded object.
- The concept of table space: The space in which a table exists, a table space is mapped to a specific data file;
- Profile Admin user password: Create profiles file name limit failed_logon_attempts 3 Password_lock_time 2; three-time login failed lock for two days
- Alter user xxx account unlock; unlock users
"8-30" Oracle Database Learning
