Common Sqlplus commands

Commonly used Sqlplus commands 1. log on to the system user sqlplus username/password @ Instance name as sysdba 2. create a tablespace create tablespace space name datafile 'file storage physical path 'size 15 M -- storage path of the tablespace, initial Value: 15 M autoExtend on next 10 M -- the Automatically increasing space value is 10 M permanet online; -- permanent use case: create tablespace sini_data DATAFILE 'd: \ oracle \ oradata \ sini_data.dbf 'size 500 m autoextend on next 1 m maxsize unlimited default storage (INITIAL 128 k NEXT 1 m MINEXTENTS 1 maxextents unlimited pctincrease 0 ); 3. create user Username identified by password; 4. Modify user password alter user Username identified by and Change Password; 5. delete user drop user Username; 6. grant the grant connect and resource to user name to the user; 7. revoke (UNDO) Permission revoke connec and resource from user name; 8. create role name; 9. Authorize the role grant select on class to student; (all users with the student role have the select permission on the class table) 10. Delete the role drop role;