个人总结oracle基本指令及常识（国外英文资料）.doc

个人总结oracle基本指令及常识（国外英文资料） Create a table space, LX - The CREATE in TABLESPACE LX DATAFILE D: \ WORKSPACE \ ORACLE \ LESSON2011_8_3 \ lx.dbf SIZE 1M -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- The ALTER in TABLESPACE MYSP1 ADD DATAFILE D: \ ORACLE_TS \ MYSPACE \ seconde.dbf SIZE 2M Change the default storage table space for the user table data: modify the data created by the SCOTT user to be stored by default in the MYSP1 table space - ALTER USER SCOTT DEFAULT TABLESPACE MYSP1; Delete tablespaces and try to ensure that the data files and data stored in the table space are deleted completely. DROP TABLESPACE MYSP1 INCLUDING CONTENTS AND DATAFILES; -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- ORACLE user, character, authority -- create a user -- CREATE USER TEST1 IDENTIFIED BY VB; -- -- -- -- -- -- -- -- -- -- -- -- -- -- - SYS - the system administrator, has the highest authority SYSTEM - - local administrator, secondary authority SCOTT - the default password is TIGER, which is ununlocked by default The delete user also removes all the data that the user has at the same time - DROP the USER TEST1 CASCADE; Change the users password -- ALTER USER TEST1 IDENTIFIED BY T123; -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- the user permissions granted table space -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - - granting access to the log-in - GRANT CREATE SESSION TO TEST1; - granting the creation table | insertion table | to delete table | to modify the table - GRANT CREATE | INSERT | DROP | UPDATE TABLE TO TEST1 The authority to use the table space is granted. GRANT the RESOURCE TO TEST1; The authority to use the table space is granted. GRANT, UNLIMITED SESSION TO ZHANGSA