OracleÓû§Ãû¸ü¸Ä²Ù×÷ËIJ½×ß
ÎÒÃǵÄOracle¹ÜÀí¹¤×÷Öо³£Éæ¼°µ½¸ü¸ÄOracleÓû§ÊôÐÔ¡¢ÃÜÂëÖ®ÀàµÄ³£ÓòÙ×÷£»µ«ÔÚijЩӦÓó¡¾°Ï£¬»áÓöµ½OracleÓû§Ãû¸ü¸ÄµÄÐèÇó£¬ÈçºÎ½â¾ö£¿ÏÂÃæÍ¨¹ýËĸö²½ÖèʵÏÖOracleÓû§ÃûµÄÐ޸ġ£
Ò»¡¢²éѯ¸ü¸ÄOracleÓû§Ãû
SQL> select user#,name,password from user$ where name ='TICKETS'; USER# NAME PASSWORD ---------- ------------------------------ ------------------------------ 78 TICKETS 21EDA78F89D6FACD
¶þ¡¢¸ü¸ÄÓû§Ãû
SQL> update user$ set name='TICKETS_BAK' where user#=78; 1 row updated. SQL> commit; Commit complete.
Èý¡¢´´½¨Í¬ÑùµÄOracleÓû§Ãû
SQL> create user tickets identified by "123456" 2 default tablespace yytickets 3 temporary tablespace temp; create user tickets identified by "123456" * ERROR at line 1: ORA-01920: user name 'TICKETS' conflicts with another user or role name
Õâʱϵͳ»áÌáʾ“Óû§Ãû³åÍ»”£¬ÔËÐÐÏÂÃæµÄSQLÓï¾ä
SQL> alter system checkpoint; ----Ç¿ÖÆÐ´ÈëÊý¾ÝÎļþ System altered. SQL> alter system flush shared_pool; ----Çå³þ»º´æÊý¾Ý×ÖµäÐÅÏ¢£¬
----Ç¿ÖÆoracle¶Áʵ¼ÊÊý¾Ý£¨¼´¸ü¸ÄºóµÄÊý¾Ý£© &nbs
Ïà¹ØÎĵµ£º
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
ÉÏ節學習開µÚÒ»個Form£¬這個節ÔÚÌí¼ÓÒ»個彈³öÏÂÀ¿ò
µÚÒ»²½£ºÌí¼Ó記錄組
1.1 選ÖÐRecord Groups
1.2 單擊Create
1.3 輸Èë²é詢SQL
1.4 單擊OK
1.5 ÐÞ¸Ä ......
1¡¢Ä¬ÈÏÊÂÀý£º
Óû§Ãû£ºscottÃÜÂ룺tiger Ö÷»ú×Ö·û´®£º±¾»ú¿ÉÒÔΪ¿Õ
2¡¢Æô¶¯·½·¨£º
ÔËÐУºsqlplus scott/tiger@lhd
3¡¢SQLPLUS»ù±¾ÃüÁ
Desc£ºÏÔʾ±í¡¢ÊÓͼ½á¹¹ desc ±íÃû£¬ÊÓͼ
List£ºÁгöSQL»º³åÇøÇøÖеÄÒ»Ðлò¶àÐÐÃüÁîÓï¾ä
Exit£ºÍ˳ö
4¡¢³£ÓõÄÊý¾Ý×Öµä(ÈýÖÖǰ׺£ºUSER£¬ALL£¬DBA)
USER_TABLE ......
OracleάÈÕ³£»¤µãµÎ
ËäÈ»Oracleά»¤²»ÊÇÎÒµÄÖ°Ô𣬵«Æ½Ê±»¹ÊÇÄÑÃâÒª¸úËü´ò½»µÀ£¬Òò´Ë¶ÔÓÚOracleµÄÈÕ³£Î¬»¤ÂÔÖªÒ»¶þ»¹ÊǺÜÓкô¦µÄ¡£
1. µÇ¼£º
£¨1£©²ÉÓÃϵͳ¹ÜÀíÔ±Óû§µÇ¼£º
#su - oracle
$ sqlplus / as sysdba
£¨2£©²ÉÓÃÒ»°ãÓû§µÇ¼£¬¼ÙÉèÓû§ÃûΪoracle£¬ÃÜÂëΪpasswor ......