Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎ¶ÁÈ¡Oracle Óû§µÄ¿ÚÁî - Oracle / »ù´¡ºÍ¹ÜÀí

ÈçºÎ¶ÁÈ¡OracleÊý¾Ý¿âÏ usersÏÂÓû§µÄ¿ÚÁîÄØ£¿Ð»Ð»´ó¼Ò
SELECT username,PASSWORD from dba_users;


²»¹ýÄã¶Á³öÀ´Ò²Ã»Ó㬿ÚÁîÊǼÓÃܹýµÄ¡£

¶¥Â¥ÉÏ¡£
Áí alter user Óû§Ãû identified by ÐÂÃÜÂë; ÊǸü¸ÄÓû§µÄÃÜÂë¡£

SQL code:
select username,password from dba_users;


ÓÐûÓаѼÓÃÜÎļþ½âÃܵÄÃüÁî°¡£¿±¾ÈËÊÇOracleµÄ²ËÄñ£¬·Ç³£¸Ðл»ØÌûµÄ£¡

ÎÒÒ²ÊDzËÄñ,µ«ÎÒ¾õµÃÓ¦¸ÃûÓÐ!! ÆÚ´ý¥Ͻâ´ð!


SQL code:
select username, password
from dba_users;


LZ¾Í±ðÏë×ÅÒª¼ÓÃܽâÃܵŤ¾ßÁË£¬Ö»ÓÐÓÃsysµÄDBAÉí·ÝµÇ¼£¬½øÓû§¹ÜÀí²Ù×÷°É£¡

Èç¹ûÓÐDBAȨÏÞ£¬²»ÏëÐ޸ıðÈ˵ÄÃÜÂ룬ÇÒÏëÓÃÄǸöÓû§µÇ¼
Ïȱ£´æÄǸöÓû§µÄÃÜÎÄ
È»ºóʹÓÃalter user identfied by values "ÃÜÎÄ"£¬ÃÜÎÄ¿ÉÒÔÊÇÄã
ÒÑÖªµÄÒ»¸öÓû§µÄÃÜÂëµÄÃÜÎÄ£¬ÕâÑùÄã¾Í¿ÉÒԵǼÁË
µÇ¼Íêºó£¬ÔÙʹÓÃÉÏÃæµÄÃüÁî¸Ä»ØÈ¥

¹Û¿´£¬½Ó·Ö

¹Û¿´£¬½Ó·Ö


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ