OracleÈÕ³£Î¬»¤µãµÎ
OracleάÈÕ³£»¤µãµÎ
ËäÈ»Oracleά»¤²»ÊÇÎÒµÄÖ°Ô𣬵«Æ½Ê±»¹ÊÇÄÑÃâÒª¸úËü´ò½»µÀ£¬Òò´Ë¶ÔÓÚOracleµÄÈÕ³£Î¬»¤ÂÔÖªÒ»¶þ»¹ÊǺÜÓкô¦µÄ¡£
1. µÇ¼£º
£¨1£©²ÉÓÃϵͳ¹ÜÀíÔ±Óû§µÇ¼£º
#su - oracle
$ sqlplus / as sysdba
£¨2£©²ÉÓÃÒ»°ãÓû§µÇ¼£¬¼ÙÉèÓû§ÃûΪoracle£¬ÃÜÂëΪpassword¡£
#sqlplus oracle/password@ssp
2. ²é¿´±í½á¹¹£¬Èç²é¿´ÏµÍ³±ídba_usersµÄ½á¹¹¡£
SQL> desc dba_users;
Name Null? Type
----------------------------------------- -------- ----------------------------
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE&
Ïà¹ØÎĵµ£º
·ÖÎöº¯ÊýÊÇoracle816ÒýÈëµÄÒ»¸öȫеĸÅÄî,ΪÎÒÃÇ·ÖÎöÊý¾ÝÌṩÁËÒ»ÖÖ¼òµ¥¸ßЧµÄ´¦Àí·½Ê½.ÔÚ·ÖÎöº¯Êý³öÏÖÒÔÇ°,ÎÒÃDZØÐëʹÓÃ×ÔÁª²éѯ,×Ó²éѯ»òÕßÄÚÁªÊÓͼ,ÉõÖÁ¸´ÔӵĴ洢¹ý³ÌʵÏÖµÄÓï¾ä,ÏÖÔÚÖ»ÒªÒ»Ìõ¼òµ¥µÄsqlÓï¾ä¾Í¿ÉÒÔʵÏÖÁË,¶øÇÒÔÚÖ´ÐÐЧÂÊ·½ÃæÒ²ÓÐÏ൱´óµÄÌá¸ß.
ÏÂÃæÖ÷Òª½éÉÜÒ»ÏÂÒÔϼ¸¸öº¯ÊýµÄʹÓà ......
² Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
² Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
² ......
ÉÏ節學習開µÚÒ»個Form£¬這個節ÔÚÌí¼ÓÒ»個彈³öÏÂÀ¿ò
µÚÒ»²½£ºÌí¼Ó記錄組
1.1 選ÖÐRecord Groups
1.2 單擊Create
1.3 輸Èë²é詢SQL
1.4 單擊OK
1.5 ÐÞ¸Ä ......
´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, Ìرð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ.
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
......
ËäÈ»ÎÒÃÇÖªµÀÉ̵À¹îÒ²,ÕâƪÎÄÕ»¹ÊÇÄܹ»ÈÃÎÒÃÇ´ÓijЩ½Ç¶ÈÉϹ۲졣±ÈÈçÅ·ÃËÓµ»¤¿ª·Å¼¼Êõ,Å·ÃËÒªÆÀ¼ÛOracleÓµÓÐMySQLºÍJavaËùÔì³ÉµÄÓ°Ïì,everything is politicalÒÑÈ»ÊÇÒ»Ìõ´ó·¹æÔòÁË£¬ÎÒÃÇ»¹ÊÇÄܹ»Ðá³öÕâ¸ö»Ï×ÓÏÂÃæÂôµÃ»¹ÊÇÀûÒæ¹Ï·ÖµÄÀϾÀ¸ð£¬×ܲ»ÄÜɶºÃʶ¼ÈÃÄãÃÀ¹úÀÐÕ¼ÁË¡£µ«ÊÇÎÒÏëÒ²Ö»ÊǸöʱ¼äÎÊÌ⣬ҲÐí±³ºóÍÆÊÖÒ ......